[PR #5511] [MERGED] Fixing MSSQL timestamp type #17820

Closed
opened 2025-11-02 16:01:20 -06:00 by GiteaMirror · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/go-gitea/gitea/pull/5511
Author: @chdxD1
Created: 12/10/2018
Status: Merged
Merged: 12/11/2018
Merged by: @lunny

Base: masterHead: patch-1


📝 Commits (2)

  • 54d454e Fixing MSSQL timestamp type
  • dfbbc56 Merge branch 'master' into patch-1

📊 Changes

1 file changed (+1 additions, -1 deletions)

View changed files

📝 models/user_heatmap.go (+1 -1)

📄 Description

MSSQL is using the wrong type here which results in a strconv.ParseInt: parsing "2018-12-07T00:00:00Z": invalid syntax error.
The added datediff(SECOND, '19700101', x) results in the unix timestamp to be returned.

This should fix #5328.


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/go-gitea/gitea/pull/5511 **Author:** [@chdxD1](https://github.com/chdxD1) **Created:** 12/10/2018 **Status:** ✅ Merged **Merged:** 12/11/2018 **Merged by:** [@lunny](https://github.com/lunny) **Base:** `master` ← **Head:** `patch-1` --- ### 📝 Commits (2) - [`54d454e`](https://github.com/go-gitea/gitea/commit/54d454e35587aa4aee0ddff04be317928db1a3d2) Fixing MSSQL timestamp type - [`dfbbc56`](https://github.com/go-gitea/gitea/commit/dfbbc560c36dd176702a7bea9252f563ea568116) Merge branch 'master' into patch-1 ### 📊 Changes **1 file changed** (+1 additions, -1 deletions) <details> <summary>View changed files</summary> 📝 `models/user_heatmap.go` (+1 -1) </details> ### 📄 Description MSSQL is using the wrong type here which results in a strconv.ParseInt: parsing "2018-12-07T00:00:00Z": invalid syntax error. The added datediff(SECOND, '19700101', x) results in the unix timestamp to be returned. This should fix #5328. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
GiteaMirror added the pull-request label 2025-11-02 16:01:20 -06:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#17820