changing AM/PM times to lower case

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

changing AM/PM times to lower case

Author

Topic

malletts
Starting Member

16 Posts

Posted - 2003-07-07 : 09:49:57

hi,

im currently usingthe following T-SQL within a stored procedure to return a time as below

select substring (convert( varchar(26),closing_time, 9),13,5)
+ ' ' + right(convert( varchar(26), closing_time,
9),2) AS "ClosingTime" from tblvacancy

which returns a time of the format 4:00 PM for example. Is there any quick way I can use the current T-SQL to return this time with the AM/PM suffix in lower case i.e. 4:00 pm

Any help greatly appreciated
Stephen

mr_mist
Grunnio

1870 Posts

Posted - 2003-07-07 : 10:20:42

look up the "lower" function in BOL. This entire job though is something that the presentation layer should probably be doing.

-------
Moo.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources