Feature Requests item #1752635, was opened at 2007-07-12 15:29 Message generated for change (Comment added) made by mr-meltdown You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=1752635&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL - general Group: None >Status: Closed Priority: 5 Private: No Submitted By: Colin Foss (cgfoss) Assigned to: Nobody/Anonymous (nobody) Summary: SQL: timestamp with time zone Initial Comment: Add support for data type "timestamp with time zone". Allow MonetDB to understand timezone rules, GMT offsets, daylight saving time shifts. ---------------------------------------------------------------------- >Comment By: Fabian (mr-meltdown) Date: 2007-07-12 15:34 Message: Logged In: YES user_id=963970 Originator: NO This already exists, and all the tricky things of time zones are tested and implemented. See also the JDBC timezone/timestamp tests. >start transaction; &4 f >create table z (i timestamp with time zone); &3 >select * from z; &1 0 0 1 0 % sys.z # table_name % i # name % timestamptz # type % 26 # length >insert into z values (now()); &2 1 >select * from z; &1 1 1 1 1 % sys.z # table_name % i # name % timestamptz # type % 26 # length [ 2007-07-12 13:32:05.000000+00:00 ] >rollback; &4 t > ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=1752635&group_id=56967 ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
