Try SYSDATE. Works for me.
Mike Amburn 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???
>
> -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.
