cheryl27284
Technical User
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?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Declare @Temp VarChar(100)
Set @Temp = 'oct 16 2005 10:35PM'
Select Convert(VarChar(5), Convert(DateTime, @Temp), 108)