Change the format to Day, Mon. DD, YYYY of Date fields on Search results using Formula SQL

To change the format of different Date fields on Saved Search results:
 
Example:
From = 10/31/2013
To = Thursday, Oct. 31,2013

Date fields can be any of the following:

a. Date  = {trandate}
b. Date Created = {datecreated}
c. Due Date = {duedate}
d. Date Billed = {billeddate}
e. Date Closed = {closedate}
f. Start Date = {startdate}
g. End Date = {enddate}
 

Steps:
1. On Customize Save Search page > under Results tab > Columns sub tab.
2. Add Formula (Text)
3. On the Formula field, add TO_CHAR({trandate},'Day, Mon. DD, YYYY')
4. Click Add
5. Click Save & Run