When designing the database set a default value of "Now()" to your date
field. When ever a record is inserted or updated the latest ODBC date/time
will be applied automatically.
Peter Tilbrook
Internet Applications Developer
Aspect Computing Pty. Ltd.
19-25 Moore Street
Turner, ACT, 2612
AUSTRALIA
http://www.aspect.com.au
Phone: (02) 6247 7677
Fax: (02) 6249 1620
Mobile: 0428 765 020
ICQ: 666275
ACT ColdFusion Users Group - http://203.37.24.198
-----Original Message-----
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 27 September 2000 1:04
To: CF-Talk
Subject: Date Timestamp??
How do I input the current date and time into a database? In other words I
want to time stamp an entry.
Rich
----------------------------------------------------------------------------
--
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.
