Sql convert long int to date time

Question

1.00/5 (1 vote)

See more:

How to convert long int to date time

samplvalue 978312168 convert it date time in sql sercer

What I have tried:

Please Help to solve this problem

Posted 23-Nov-16 22:04pm

moin1

Updated 24-Nov-16 18:43pm

Add a Solution

Comments

Suvendu Shekhar Giri 24-Nov-16 3:19am

What!!!
Seriously?
Why do you want to convert a long int to a datetime?
Which database are you using?
What is the logic to get date time components from it?

Suvendu Shekhar Giri 24-Nov-16 3:20am

Well, there is no "long int" in SQL Server, you probably are referring to "bigint".

moin1 24-Nov-16 4:22am

From attendance machine i get long int and need to convert into date time

Patrice T 24-Nov-16 3:37am

What is supposed to be "978312168" ? where does it come from ?

moin1 24-Nov-16 4:22am

From attendance machine i get long int and need to convert into date time

Patrice T 24-Nov-16 5:04am

You need to know what is the meaning of the value.

StackQ 25-Nov-16 2:27am

from your machine, you have picked wrong value to convert into datetime, check and pick correct convertible value

2 solutions

Add a Solution

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

CPallini · Answer 1 · 2016-11-23T22:47:00

Solution 1

Probably you wish to convert Epoch timestamp to sql server(human readable format) - Stack Overflow[^].

Posted 23-Nov-16 22:47pm

CPallini

Daniel Jones · Answer 2 · 2016-11-24T18:43:00

Solution 2

SQL

Select Convert(DATETIME, LEFT(978312168, 9))

Posted 24-Nov-16 18:43pm

Daniel Jones

Comments

moin1 25-Nov-16 23:12pm

Do not work

Sql convert long int to date time

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Sql convert long int to date time

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us