advanced code snippet search

Posted By

g8rpal on 08/31/10


Tagged

sql date simple part


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

hchattaway
Tyster
johnw


only select date part from datetime

 / Published in: SQL
 

URL: http://blog.sqlauthority.com/2007/06/10/sql-server-retrieve-select-only-date-part-from-datetime-best-practice/

Expand | Embed | Plain Text 
  1. SELECT CONVERT(VARCHAR(10),GETDATE(),111)

Report this snippet  

You need to login to post a comment.