<pre><code>SELECT GETDATE()
</code></pre>

<p>Returns: <code>2008-09-22 15:24:13.790</code></p>

<p>I want that date part without the time part: <code>2008-09-22 00:00:00.000</code></p>

<p>How can I get that?</p>

Try this:
```
```
SELECT CONVERT(VARCHAR(10),GETDATE(),111)
```
```
The above statement converts your current format to
```
YYYY/MM/DD
```
, please refer to
this link
to choose your preferable format.