Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a field where date is having values like 1226034855. I want to convert this data based on EST Timezone.
Can you please help me in this date conversion.
Hi,
go through below link
Regards
Hi!
Can you try this and see if it return the correct value
Timestamp(time/86400+25569) AS DateTime,
DATE(time/86400+25569) AS Date,
The result for 1226034855 will be 2008-11-07 05:14:15