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 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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

