[MonetDB-users] How to convert time from seconds to Year Month Day...

Thanks to people out there for providing excellent answers.

I have time values in the form of seconds since 1970/01/01 00:00:00.000 GMT e.g. "1087488000".

How could I convert them into Year, Month, Day, Hour, Minute, and Second.

Iftikhar