At 09:58 AM 13-02-02 -0300, Galante Hernan wrote:

>Hi everybody,
> I have a problem, I'm working with excel to do some inserts
>stataments depending on what information I must upload to the IBASE. I have
>Date Constants, like '10-JAN-01', how it must be in the SQL statament, is
>like:
>
>Insert into WorkTable (Field1, Field2, ..., TimeStampField, ...)
> values (x,x, ..., '10-JAN-01', ...)
>
>??
>I'm working with IB6

Insert into WorkTable (Field1, Field2, ..., TimeStampField, ...)
values (x,x, ..., CAST('10-JAN-01' AS TIMESTAMP), ...)

Please trim your messages.

H.

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________