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]
