[MonetDB-users] timestamp conversion failed -How can I convert a char string to a timestamp
Hi,
I am trying to insert the following value into a timestamp column:
'2/5/2008 4:05:31 PM'
and I get the error message: !SQLException:timestamp:conversion of string '2/5/2008 4:05:31 PM' failed
I would like to convert that date string into a timestamp type - is there a function in Monet to do that?
On 21-10-2009 13:08:55 -0400, Roman Sokolyuk wrote:
I am trying to insert the following value into a timestamp column:
'2/5/2008 4:05:31 PM'
and I get the error message: !SQLException:timestamp:conversion of string '2/5/2008 4:05:31 PM' failed
I would like to convert that date string into a timestamp type - is there a function in Monet to do that?
MonetDB just doesn't support this date format. It would if it were like '2008-02-05 16:05:31'. I'm not aware of more clever conversion tricks, maybe others are.
Thanks. It Worked !!!!
On Wed, Oct 21, 2009 at 1:12 PM, Fabian Groffen Fabian.Groffen@cwi.nlwrote:
On 21-10-2009 13:08:55 -0400, Roman Sokolyuk wrote:
I am trying to insert the following value into a timestamp column:
'2/5/2008 4:05:31 PM'
and I get the error message: !SQLException:timestamp:conversion of string '2/5/2008 4:05:31 PM' failed
I would like to convert that date string into a timestamp type - is there a function in Monet to do that?
MonetDB just doesn't support this date format. It would if it were like '2008-02-05 16:05:31'. I'm not aware of more clever conversion tricks, maybe others are.
Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Fabian Groffen -
Roman Sokolyuk