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/

  1. SELECT CONVERT(VARCHAR(10),GETDATE(),111)

Report this snippet  

You need to login to post a comment.