> How do I set the default current date in SQL 7
The function getdate() will return the current date/time in SQL 7. If you
want a field that is set to the current date/time when a record is inserted,
add a datetime field to the database and set the default value to getdate().
- Sean
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sean Daniels
Manager, Engineering
Marketplace Technologies
[EMAIL PROTECTED]
tel: 207.439.6030
cel: 978.764.0799
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://www.dealstream.com
http://www.mergernetwork.com
http://www.dealforce.com
------------------------------------------------------------------------------
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.