Sorry, should be
set dateformat mdy declare @datevar smalldatetime select @datevar = getdate() select convert(smalldatetime, @datevar, 101) There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown ----- Original Message ----- From: "Joshua Tipton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 22, 2002 5:15 AM Subject: sql Help > set dateformat mdy > declare @datevar smalldatetime > set @datevar = 'select getdate()' > select convert(smalldatetime, @datevar, 101) > > > How come this is not working. I am trying to get the current date stored in a variable in a mm/dd/yyyy format. Please Help. > > Joshua Tipton > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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