Board index » delphi » Writing date

Writing date

I want to write a date to Oracle's date type field.

If  i write in a string the date like 14/02/2000 it seems to work but when i
add time
like 14/02/2000 04:12:34 it doesn't work.
Do i have to convert the date in date format or is there any string format
accepted?

Thanks,

Ren Marzolf

 

Re:Writing date


Use the TO_DATE built in function, supplying the date/time format you are
using.

Regards,
Danny Mavromatis
Sydney Australia.

Quote
MARZOLF wrote in message <889vo0$i...@bornews.borland.com>...
>I want to write a date to Oracle's date type field.

>If  i write in a string the date like 14/02/2000 it seems to work but when
i
>add time
>like 14/02/2000 04:12:34 it doesn't work.
>Do i have to convert the date in date format or is there any string format
>accepted?

>Thanks,

>Ren Marzolf

Other Threads