At 06:56 PM 7/6/00 -0400, you wrote:
>does anyone know why oracle would not accept timestamps?
>
>when i try to insert Now() into a date/time field, oracle returns with the
>error "illegal character". FYI, Now() outputs a timestamp like:
> {ts 'yyyy/mm/dd hh24/mi/ss'}
>
>stranger yet... all my queries work when i run the application locally on a
>workstation with an ODBC connection out to the database. however, the
>application refuses to work when i run the application locally on the
>database.
>
>the workstations are Win2000, CF 4.5.1 Ent, Oracle 8.1.6.0 ODBC driver
>the server is WinNT SP6a, CF 4.5.1 Ent, Oracle 8.1.6.0 ODBC driver
>
>ideas???
I had the best luck formatting the dates into yyyy-mm-dd and putting
TO_DATE(#variable) in the sql statement. I think that's right. At any rate,
if you have some docs around, look up the TO_DATE function and it'll help
you out.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
