We are trying to set up a job in SQL Server 2000 so that at a certain day and time, a column in our database will be updated with the current date but not the time.
The following works:
Set newdate = GetDATE ()
but it dumps in the full date and time of the server. We just need the date and we do NOT want the time.
The date needs to be in the format of mm/dd/yyyy . Nothing I have tried so far works. I keep getting all kinds of errors. Could someone please correct the code I have above to what it should read, to update the column newdate, with the correct date without the time?