chewy
SuperNintendo Chalmers
- Local time
- Today, 07:21
- Joined
- Mar 8, 2002
- Messages
- 581
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!
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!