Converting a timestamp to a date

[#1]

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

[#2]

Héctor, the website is not accessable any more

[marcelo_7]

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!

[perla_chirag]

Thanks Yves!

Was looking for this conversion

[menta]

May be the changing to legal time?