Need to use SQL date format yyyy-mm-dd
Paolo > -----Original Message----- > From: Giles Roadnight [mailto:[EMAIL PROTECTED]] > Sent: 03 October 2002 14:43 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] OT: SQL Server Query > > > Hi > > Sorry for the off topic post. > > I have some SQL server tables that have a month and a year > column and I want > to put them both into one date column. I have tried the > follwoing query but > all of hte dates get set to the first of january 1900. > > Update AV_Cluster > set StatsDate = 13/[AV_Cluster].[Month]/[AV_Cluster].[year] > > I have tried putting quotes around bits of the date and > adding &'s and +'s > in to join the string together but I got lots of errors. > What am I doing wrong? > > Thanks > > Giles > > > -- > ** 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]
