getdate tsql question

How do I write TSQL that it calculates the following:

1. the开发者_JS百科 current date and mid night such as 2010-12-01 00:00:00.000
2. the current date and 6pm such as 2010-12-01 18:00:00.000

Thanks..

---

You can try something like the following

SELECT DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0) AS DateNoTime, 
    DATEADD(hh, 18, DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)) AS DateNewTime

---

1. dateadd(dd,datediff(dd,0, getDate()),0)
2. dateadd(hh,18 + (24 *datediff(dd,0, getDate())),0)