use need the TIMESTAMP var type in cf. > -----Original Message----- > From: Paul Johnston [mailto:[EMAIL PROTECTED] > Sent: 13 January 2004 10:44 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Strange T-SQL issues > > > I am having issues putting a date/time from CF into SQL > Server. I am sure it's simple, but I can't seem to get the > time into the server (date is no problem). > > Running this code in Query Analyzer produces the correct > output (ie a date with the right time): > > DECLARE @sd varchar(30) > SELECT @sd = '2003-10-19 12:23:03' > > DECLARE @dt datetime > SELECT @dt = CONVERT(datetime, @sd, 120) > > SELECT @dt as dt > > However, if I insert in a date via a Stored Procedure (either > as a cf_sql_date or cf_sql_varchar and convert to date) > either way it removes the time and just inserts the date. > > Anyone? > > Paul > -------------------------- > Paul Johnston > PJ Net Solutions Ltd > E: [EMAIL PROTECTED] > M: +44 7866 573013 > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] >
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
