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

Filed under:
|

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

Related posts about sql-server

Related posts about sql