Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Bolding a date called from the db Expand / Collapse
Author
Message
Posted Thursday, June 27, 2013 3:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 27, 2013 3:46 PM
Points: 2, Visits: 2
Hi,

I know others have asked a similar question, but, being a newbie, I'm unable to figure out how to apply those situations here.

Someone coded something for me, but I now want to bold part of the data returned for a document (specifically, the date)

The code in question is:

SELECT TRIM(TO_CHAR(TO_DATE(INFOVALUE, 'MON DD, YYYY')+20,'Month'))||' '||TRIM(TO_CHAR(TO_DATE(INFOVALUE,'MON DD, YYYY')+21,'DD, YYYY' ))AS approval_date
FROM FOLDER WHERE CODE=100;

So, I want the whole date to be bold. Much appreciated
Post #1468362
Posted Thursday, June 27, 2013 3:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 27, 2013 3:46 PM
Points: 2, Visits: 2
Never mind. I figured it out - easier than I expected - I was over-thinking it
Post #1468371
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse