SQL Query help

[chewy]

I have a table in an SQL database. The field data is in the format "12/29/2003 1:00:00 PM"
I cannot change that! I was wondering how to run a query that will change all the dates with "12/29/2003" irregardless what the time was.

I have this

UPDATE POSTransHist
SET POSTransHist.DateTime = '12/29/2003 1:00:00 PM'

WHERE (POSTransHist.DateTime = '1/5/2004*' )

Any help would be appreciated. Sorry to post this here and not the SQL forum.

WOW 3 posts in 1 day!

 

[WayneRyan]

chewy,

Instead of single-quotes, use:

#12/29/2003#

Wayne

 

[chewy]

i shall try thanks

 

[chewy]

didn't work. any other ideas?