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!

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

Date Functions

Status
Not open for further replies.
dmando84

dmando84

Programmer
Joined
Dec 28, 2005
Messages
68
Location
US
Hello,

Does anyone know how to change the time on a column of datatype datetime? I forgot how to do this....

Thank you
 
Sort by date Sort by votes
Change it how?

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
change all occurrences of 8:15 on a thursday to 9:37 on the following saturday

???

;-)

r937.com | rudy.ca
 
Upvote 0 Downvote
I used DateAdd(). I thought it would be difficult. Thanks for your responses.

Dave
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question Question
How te filter by date ?
Replies
9
Views
956
dhookom
dhookom
peac3
  • Locked
  • Question Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
923
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question Question
Last date per userid
Replies
3
Views
503
Andrzejek
Andrzejek
niall5098
  • Locked
  • Question Question
Create plan guide with date time parameters
Replies
3
Views
531
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question Question
How to get monther per part id from last date to current date and include remaining date ?
Replies
7
Views
706
JohnBayne
JohnBayne

Part and Inventory Search

Sponsor

Back
Top