dATE PART 1

[JazzMaan]

I have date in the format of '6/1/2005 2:00:00 PM'

and

I would like to convert it to '6/1/2005'.

Is there any function available to do this ??

 

[Catadmin]

CONVERT(char(10),MyDate,101)

Note: 101 is the American style of reading a date, not European.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???