On Wed, Oct 21, 2009 at 1:12 PM, Fabian Groffen <Fabian.Groffen@cwi.nl> wrote:

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