Hi Steve,

Try,

Insert into TABLEXYZ (COLUMNXYZ)
Values (cast('23-OCT-2002 18:00:00' as datetime));

[]'s
Marcelo

> ----- Mensagem original -----
> De: Stephen Wood [SMTP:stephenw@...]
> Enviada em: terça-feira, 7 de janeiro de 2003 09:31
> Para: ib-support@yahoogroups.com
> Assunto: [ib-support] Question about inserting a Date and
> Time
>
> Hi guys,
>
> I'm having a little problem getting the format correct to insert a date
> and
> time into a column, can anyone tell me what the format is because I can't
> seem to find it in the Firebird documentation....for example, I'm
> trying...
>
> Insert into TABLEXYZ (COLUMNXYZ)
> Values ('23-OCT-2002 18:00:00');
>
> And all other variations I've tried throw a conversion error every
> time....
>
> Thanks
> Steve
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>