Yes, I agree completely. It also has the characteristic that the time
is that of the database server, not the webserver. In this example,
that may be a good or a bad thing if the person is updating/inserting
other types of dates into their tables.
We always use SP's for updates / inserts, and always reference the time
to the database machine, so as to remain consistent. I actually prefer
this method of encapsulation, but to each his/her own...
Steve
At 10:37 AM 7/10/2000 -0400, James Hancock wrote:
>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/[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.
>>
>
>--
>Stephen Garrett
>GPS
>[EMAIL PROTECTED] (360) 896-2714
>ICQ# 10776767
>----------------------------------------------------------------------------
>--
>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.
>
--
Stephen Garrett
GPS
[EMAIL PROTECTED] (360) 896-2714
ICQ# 10776767
------------------------------------------------------------------------------
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.
