Answers for "get epoch from date time"

SQL
0

epoch to datetime

#--------------------------------SQL SERVER----------------------------------
#use this to convert forom bigint unix to datetime
#replace 1500123123 with your number
select  DATEADD(second,1500123123, CAST('1970-01-01 00:00:00' AS datetime))

#it's way better to put this in a function and call the function
Posted by: Guest on December-02-2021
1

datetime to epoch

>>> datetime.datetime(2012,4,1,0,0).timestamp()
1333234800.0
Posted by: Guest on May-26-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language