Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TMDOSS
Starting Member
33 Posts |
 Posted - 2009-06-05 : 14:56:39
|
| How Can I display time only from a small date time with AM and PM . If I use convert statement to display time it displays 13.00,13.01,but user needs to see 01.00 PMis it possible? |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-06-05 : 15:09:28
|
| If you're using a front end application to present your sql data then you should format the datetime there. Otherwise:look at Books Online for different format options in "Cast and Convert"Here's one option:select convert(varchar, getdate(), 131)Be One with the OptimizerTG |
 |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
|
|
|
|
|
Time with AM/PM