Re: [MonetDB-users] timestamp conversion failed -How can I convert a char string to a timestamp

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.