Anything to do with the "date" being the integer part of the underlying number? Perhaps CF_SQL_DATE is mapped to Integer or Smallint.
Do MM anywhere specify the mappings of CF_SQL_XXX to the actual DB types - which I suppose could also vary per DB engine? Duncan -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 January 2004 11:58 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Strange T-SQL issues I have no idea, it appears to be one of those weird decisions the CF engineers made. I'm assuming the date var type just takes the date and not the time - you could test this if you have some time. > -----Original Message----- > From: Damian Watson [mailto:[EMAIL PROTECTED] > Sent: 13 January 2004 11:40 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Strange T-SQL issues > > > Yup, that would do it. Can you tell us why though Rich, tis > most perplexing! It had me screwed for quite some time. > > d > > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 13 January 2004 10:47 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Strange T-SQL issues > > 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] > > > -- > ** 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] -- ** 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]
