Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update date within datetime field

Status
Not open for further replies.

steve4king

IS-IT--Management
Feb 6, 2007
154
US
I am looking to update a table to set the date in a date/time field without affecting the time.. Is there a simple way to do this?

Example, I have a table that shows DTS = 06/21/81 03:12:09
I want to change that to show 04/30/08 03:12:09.

There are an unknown number of records I want to change like this.

Thanks,
Steve W.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top