[Monetdb-developers] timestamp

Stefan Manegold Stefan.Manegold at cwi.nl
Thu Apr 1 12:28:55 CEST 2004


> 
> 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 at 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       |




More information about the developers-list mailing list