On Mon, Feb 11, 2008 at 03:33:10AM -0800, Iftikharn wrote:
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.
I added an extra sql file in src/sql, called temporal.sql. If this is loaded (on the latest stable) you get a function which can convert ints into timestamps. From this you can as said extract hours etc. The convert function is called epoch(int). There is also a new function epoch(timestamp) which returns the number of seconds since epoch. Niels
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.
------------------------------------------------------------------------- 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