You should use the to_date() function with about a hundred options.
:)
Chris
Christopher Conrad
Victoria's Secret Catalogue
http://www.VictoriasSecret.com
Senior.Programmer.Analyst
614.337.5653
[EMAIL PROTECTED]
> -----Original Message-----
> From: Mike Amburn [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 06, 2000 6:56 PM
> To: Cf-Talk
> Subject: oracle & timestamps
>
> 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???
>
> -mike
>
> --------------------------------------------------------------------------
> ----
> 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.
------------------------------------------------------------------------------
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.
