Extracting and Formatting a DateTime column in SQL Server 2008
I'm using SQL Server 2008 and have a query in which I need to extract a column defined as a DateTime and put it in the following format:
I know in SQL Server 2012 it has functions to do this but I have NO idea how to achieve this in 2008 version.
11:15:45 AM
11:30:33 AM
11:45:05 AM
12:00:23 PM
12:15:48 PM etc.I know in SQL Server 2012 it has functions to do this but I have NO idea how to achieve this in 2008 version.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That won't work because 8 uses 24-hour hours, i.e., you'll get "13:nn:nn PM" or "17:nn:nn PM", etc..
I prefer the method I posted above, although you could also use format 8 and subtract 12 hours when appropriate to change 13 to 1, 17 to 5, etc..
I prefer the method I posted above, although you could also use format 8 and subtract 12 hours when appropriate to change 13 to 1, 17 to 5, etc..
ASKER
I actually want the military time format (even though I don't need the AM/PM)....
If you just want military time, you can do:
CONVERT(varchar(8), datetime_column, 8) AS formatted_time,
CONVERT(varchar(8), datetime_column, 8) AS formatted_time,
ASKER
It still didn't come out right. I'll just keep what I had.
Thanks!
Thanks!
ASKER
This solution worked...but I also figured it out.
ASKER
I acutally figured it out. Here is what the code and the result look like (see screenshot).
If your way is a better, please let me know why!
Thanks!
screenshot.jpg