[Monetdb-developers] timestamp

Fabian Fabian.Groffen at cwi.nl
Thu Apr 1 11:46:29 CEST 2004


you should prefix timestamp strings with "timestamp", ie
timestamp '2003-11-26 10:36:53'

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
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers




More information about the developers-list mailing list