What you want to do is trim off the time... Try this:
Cast(floor(cast(getdate() as float)) as smalldatetime) That'll trim the time off... -----Original Message----- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 4:42 PM To: CF-Talk Subject: Getdate() Date only no time. Could someone show me a replacement or another way to use GetDate in a query in a stored procedure, so that getdate() would only return the month/day/year. I know I could do datepart but how would that be in something like Insert Into Table (MyDate) Values(getdate()) Thanks, Neil ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
