Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I didn't find out in the post a solution of this issue.
I have a file with a date in timestamp in seconds.
I'd like to display the date in format 'YYYY-MM-DD'.
How ?
Thanks for any help
JJJ
Héctor, the website is not accessable any more
I have a timestamp 1141146494. When I use the function FROM_UNIXTIME(Time) it returns 2006-02-28 18:08:14 but the timestamp solution you proposed returns 2006-02-28 17:08:14. What am I missing?
Update: it seems Online Conversion - Unix time conversion says the same thing your function does so I assume the SQL function is at fault. Thanks!
Thanks Yves!
Was looking for this conversion
May be the changing to legal time?