Integer to Datetime SQL

Question

I need convert this integer "1469416462" to datetime in format dd-mm-yyyy hh:mm:ss . Any ideas?

My Intent:

select CONVERT (datetime,1469416462)

You'll might find a solution here: https://stackoverflow.com/questions/2904256/how-can-i-convert-bigint-unix-timestamp-to-datetime-in-sql-server — GreenSmurf, Jul 11 '17 at 17:14

score 0 · Accepted Answer · answered Jul 11 '17 at 17:14

0

The value 1469416462 looks like a Unix-Timestamp.
Unix-Timestamp: Seconds since 1.1.1970
So the solution would be easy like:

For MySQL:

SELECT from_unixtime(1469416462)

answered Jul 11 '17 at 17:14

Esteban P.

FUNCTION MydataBase.DATEADD does not exist – Alexis Cervetto Jul 11 '17 at 17:19
@AlexisCervetto i just changed it. before the question was not tagged with mysql! – Esteban P. Jul 11 '17 at 17:19
This works! thanks you dude! – Alexis Cervetto Jul 11 '17 at 17:22
@AlexisCervetto: Perfect! Don't forget to mark the anser as accepted, so other users can find the working solution – Esteban P. Jul 12 '17 at 06:49

1 Answers1