The oracle reserved word SYSDATE will achieve a current timestamp without
all the hassle of formatting.
INSERT INTO DATA_TABLE(NAME, DATE)
VALUES ('#name#', SYSDATE)
j.
-----Original Message-----
From: Stephen Garrett [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 07, 2000 1:57 PM
To: [EMAIL PROTECTED]
Subject: RE: oracle & timestamps
The default syntax of the Oracle TimeStamps is set by the DBA. I always
use the TO_CHAR function on date stamps and format them the way I want
for display. (used in the SQL statement)
Steve
At 08:32 AM 7/7/2000 -0400, [EMAIL PROTECTED] wrote:
>I would guess that the default Oracle date format on the two machines is
set
>differently. Unfortunately a cursory search did not turn up info on
>how/where this is set.
>
>-----Original Message-----
>From: Mike Amburn [mailto:[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/cf-talk@houseoffusion.com/
>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/cf-talk@houseoffusion.com/
>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.
>
--
Stephen Garrett
GPS
[EMAIL PROTECTED] (360) 896-2714
ICQ# 10776767
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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.
