you should prefix timestamp strings with "timestamp", ie timestamp '2003-11-26 10:36:53'
that only applies to SQL, not to MIL and/or "plain" asci_io. Arjan, do you have to monettime module loaded both when loading the data and when checking the results (i.e., when running the ls or dir)? Stefan
Arjan Scherpenisse wrote:
Hi list,
I am importing some tab-separated dump data in which a field is a timestamp, formatted ala "2003-11-26 10:36:53". After importing (through make_persistent/load_data), the two timestamp BATs show up as:
[ "profile_track_history_date", "oid", nil, 4516232, 0, "clean", "disk", "pers", 0, 1 ]
[ "profile_track_history_serverdate", "oid", nil, 4516232, 0, "clean", "disk", "pers", 0, 1 ]
(having a 'nil' tail-type). I guess this is a minor bug; because the BATs are filled with timestamps properly.
regards, Arjan
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |