Niels Thanks a lot for your reply. Actually the seconds e.g. "1087488000" are stored as number (longint), they are not stored as timestamp. In this case what should be the appropriate approach. Regards, Iftikhar Niels Nes wrote:
On Sun, Feb 10, 2008 at 04:00:41PM -0800, Iftikharn wrote:
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".
ie you have timestamps?
How could I convert them into Year, Month, Day, Hour, Minute, and Second.
Use the sql temporal syntax, for example
extract (year from ts )
Where ts is your timestamp value
Niels
Iftikhar -- View this message in context: http://www.nabble.com/How-to-convert-time-from-seconds-to-Year-Month-Day...-... Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
--
Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context: http://www.nabble.com/How-to-convert-time-from-seconds-to-Year-Month-Day...-... Sent from the monetdb-users mailing list archive at Nabble.com.