converting date in SQL to shortdate

[cheryl27284]

Here is an easy question for you pros. I was unable to find this anywhere. I need to convert a date that looks like this: oct 16 2005 10:35PM into this 22:35.. What is the function to convert to shortdate?

 

[gmmastros]

Copy/paste this in to a query analyzer window to see how it works.

Declare @Temp VarChar(100)
Set @Temp = 'oct 16 2005 10:35PM'

Select Convert(VarChar(5), Convert(DateTime, @Temp), 108)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[earthandfire]

If you look up Convert in BOL you will see a table of conversion codes for the style parameter (which will explain what the 108 in gmmastros' solution does).

Hope this helps.