Datetime

[sardinka2]

From I query I have a data returning back as:
9/1/2004 12:00:00 AM
I would like to get only date without time.what function should I use.

 

[john76]

You can use the CONVERT function to change the datetype to varchar, then apply the style of your choice.

SELECT CONVERT(varchar, MyDateField, 101)
  FROM MyTable

This example of the 101 syle returns mm/dd/yyyy format.

HTH,
John

 

[jmk418]

hi
you can use the left function to pull back the number of characters from the left that you need or use the convert function to pull back the date

left("field name", (number of characters)
convert(varchar (10), "field name", style)

style 101 returns the date as mm/dd/yyyy

jeremy