or

Now()

Mark Stephenson
New Media Director
Evolution Internet
T: 0870 757 1631
F: 0870 757 1632
W: www.evolutioninternet.co.uk
E: [EMAIL PROTECTED]


This email, together with any attachments, is for the exclusive and
confidential use of the addressee(s).  Any other distribution, use or
reproduction without the sender's prior consent is unauthorised and strictly
prohibited.  If you have received this message in error, please
notify the sender by email immediately and delete the message from your
computer without making any copies.




-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2002 13:38
To: CF-Talk
Subject: RE: SQL Server - default to current date


in the default for the field
wouldn't you just put

getdate()


.tony

Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337

-----Original Message-----
From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 22, 2002 8:36 AM
To: CF-Talk
Subject: SQL Server - default to current date


What's the syntax for inserting the current date as a default value in
SQL
Server?

Dave Bosky, Net+
~HTC Senior Multimedia Web Designer
~Phone: 843.369.8613
~Fax: 843.369.8715
~Email: [EMAIL PROTECTED]




HTC Disclaimer:  The information contained in this message may be
privileged and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you
are hereby notified that any dissemination, distribution or copying of
this communication is strictly prohibited.  If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.  Thank you.


______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to