I want to update date in sql with asp project.Im using this query
UPDATE FORCAST SET F_DUEDATE = DAY(1) WHERE (F_CONTRACT = 'hpky000190') AND (F_SERIAL BETWEEN '1' AND '10')
But Day update Like this.
Ole Date = 9/18/2008
Updated Date = 1/19/1900 12:00:00 AM
Bt I want to that date updated like 9/19/2008.
Please help me.