Set time part of datetime variable to 18:00
Posted
by maxt3r
on Stack Overflow
See other posts from Stack Overflow
or by maxt3r
Published on 2010-05-17T09:21:01Z
Indexed on
2010/05/17
9:31 UTC
Read the original article
Hit count: 207
sql-server
|sql
Hi. I need to set datetime variable to two days from now but it's time part must be 18:00.
For example if i call getdate() now i'll get 2010-05-17 13:18:07.260. I need to set it to 2010-05-19 18:00:00.000.
Does anybody have a good snippet for that or any ideas how to do it right?
© Stack Overflow or respective owner