how to take just date from datetime code example
Example 1: sql display today's date
SELECT getdate()
Example 2: sql server format datetime to short date
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
SELECT getdate()
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )