how to convert bigint to datetime in sql server

Question

0.00/5 (No votes)

See more:

Hello,
how to convert bigint to datetime in sql server i have some bigint values and their correponding datatime values but i am not able to find logic behind it..

Value(Bigint)--- Datetime
1333270800------ '2012-04-01 09:00:00.000
1333274400------ '2012-04-01 10:00:00.000'
381403800------- '1982-02-01 09:30:00.000'
1270116000------ '2012-02-26 10:00:00.000'
127013003------- '2012-04-01 10:00:00.000'

Please reply how to convert this values into datetime

Thanks
Srishti

Posted 28-Sep-14 21:14pm

srishti_

Add a Solution

2 solutions

Solution 1

Check the below link.

how to convert bigint to datetime in sql server[^]

Hope this link helps.

Posted 28-Sep-14 21:22pm

ChauhanAjay

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Accepted Answer · 2014-09-28T21:33:00

Solution 2

It seems that the number represents the second since the unix epoch (1/1/1970)...
You can get SQL datetime out of it with this command:

SQL

SELECT DATEADD(S, @your-big-int, '19700101')

Posted 28-Sep-14 21:33pm

Kornfeld Eliyahu Peter

Comments

srishti_ 29-Sep-14 8:21am

Thanks a lot

how to convert bigint to datetime in sql server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to convert bigint to datetime in sql server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us