SQL Server Date in INT but it's not epoch time

ep6jt1vc 于 2023-06-21 发布在其他

关注(0)|答案(1)|浏览(113)

I have '77337' and '4477877' delcared as INT in a client's database in SQL Server. Their app displays the following date and time as 9/24/2012 and 12:26 respectively. How were these computed?

From the database:

From the application:

I tried use epoch time or unix time, but it's a far match

Edited the screenshots for more examples

sql-server

来源：https://stackoverflow.com/questions/76462434/date-in-int-but-its-not-epoch-time

1条答案

按热度按时间

xmakbtuz1#

As mentioned by @zhorov in comments the entrydate values are number of days after 1800-12-28 , so the complete calcul can be :

select *, CONVERT(date, (DATEADD(day, entrydate, '1800-12-28'))) AS DATE,
          FLOOR(entrytime/3600/100) AS HOURS , 
          FLOOR(entrytime/3600%100*60/100) AS MINUTES
from mytable

Result :

entrydate	entrytime	DATE	HOURS	MINUTES
77337	4477877	2012-09-24	12	25
77418	3135704	2012-12-14	8	42

Demo here

赞(0）回复(0）举报 2023-06-21

我来回答

SQL Server Date in INT but it's not epoch time

1条答案

相关问题

热门标签

最新问答