Feature Requests item #2539357, was opened at 2009-01-27 04:52 Message generated for change (Comment added) made by mr-meltdown You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2539357&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: None Group: None Status: Open Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) >Summary: SQL: add timestamp parsing support for POSIX(?) notation (Z) Initial Comment: CREATE TABLE nodes_legacy (id integer, long double, lat double, username varchar(255), timestamp timestamptz); COPY 6833589 RECORDS INTO nodes_legacy from '/mnt/dv/adt/temp/tmp/nodes.csv' USING DELIMITERS ',', '\n', ''''; !SQLException:sql:value '2008-10-11T06:54:34Z' while parsing '2008-10-11T06:54:34Z'' from line 0 field 4 not inserted, expecting type timestamp !SQLException:importTable:failed to import table 35835479, 51.9745073, 7.2971406, 'Fam-Os', '2008-10-11T06:54:34Z' 53989466, 51.974842, 7.2967195, 'Fam-Os', '2008-10-11T06:54:34Z' 53989477, 51.9781241, 7.2954519, 'Fam-Os', '2008-10-11T06:54:34Z' 53989479, 51.9789966, 7.2952828, 'Fam-Os', '2008-10-11T06:54:34Z' 53989481, 51.9795392, 7.2952676, 'Fam-Os', '2008-10-11T06:54:34Z' 53989483, 51.9805516, 7.294534, 'Fam-Os', '2008-10-11T06:54:34Z' 53989485, 51.981326, 7.2940894, 'Fam-Os', '2008-10-11T06:54:34Z' 53989546, 51.9750623, 7.2964489, 'Fam-Os', '2008-10-11T06:54:34Z' 53989558, 51.9785337, 7.295313, 'Fam-Os', '2008-10-11T06:54:34Z' 53989562, 51.9778826, 7.2955678, 'Fam-Os', '2008-10-11T06:54:34Z' 54354966, 51.9791179, 7.2952621, 'Fam-Os', '2008-10-11T06:54:34Z' 291835846, 51.9782565, 7.2953858, 'Fam-Os', '2008-10-11T06:54:34Z' 301779697, 51.9786924, 7.2953026, 'Fam-Os', '2008-10-11T06:54:34Z' 301779712, 51.9786557, 7.295305, 'Fam-Os', '2008-10-11T06:54:34Z' 303693820, 51.9803148, 7.2947056, 'Fam-Os', '2008-10-11T06:54:34Z' (likewise without '') ---------------------------------------------------------------------- >Comment By: Fabian (mr-meltdown) Date: 2009-12-01 10:15 Message: made subject reflect what the request is about, maybe helps to get it implemented as it doesn't seem awfully hard to implement this ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2009-02-09 15:44 Message: I am making this report a feature request. Niels (SQL god father gave green light for that).... we need to support the Z we need to follow the Z semantics too, Z == time zone Zero). ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2009-02-09 15:22 Message: Niels, Is this a feature request or bug? ---------------------------------------------------------------------- Comment By: Lefteris Sidirourgos (lsidir) Date: 2009-01-27 08:49 Message: Indeed the time module does not parse the Z (at least that was the case in M4 and I am guessing that is the case also in M5). I would suggest to add the Z in the parsing of timestamps, also because the XQuery dateTimes use Z too:) ---------------------------------------------------------------------- Comment By: Stefan de Konink (skinkie) Date: 2009-01-27 05:10 Message: Seems the problem fixes it self by removing the 'Z' from the data time... ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2539357&group_id=56967 ------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
