problem converting dates 1

[psimon88]

I have a field dtmTimeStamp that comes across as 8/29/2005 10:45:58 PM.

I am only interested in the date.

Another date field comes across normall as 8/29/05

When I do a 'left' SELECT LEFT(dtmTimeStamp , 11) AS date, it comes across as Aug 29, 2005

I'm sure that there's a cast or convert format for this (particularly to format 110 on the msdn site), but can anyone help me with the command?

Thanks.

 

[cmmrfrds]

Convert(varchar(10),dtmTempStamp,101) as mydate

provided this is a date field. The sql server timestamp data type is not a date field.

 

[psimon88]

thank you very much. Exactly what I wanted.