Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part V: Appendixes > Date Format Masks

Date Format Masks

The following sections contain a full list of the format masks that can be used within the TO_ CHAR and TO_DATE functions in Discoverer, along with an example value based on Monday, July 24, 2006.

Day Format Masks

MaskDescriptionExample
DNumber of the day of the week2
DDNumber of the day of the month24
DDDNumber of the day in the year, since January 1st205
DYThree-letter uppercase abbreviation of the dayMON
DyThree-letter INITCAP abbreviation of the dayMon
dyThree-letter lowercase abbreviation of the daymon
DAYThe uppercase full name of the dayMONDAY
DayThe INITCAP full name of the dayMonday
dayThe lowercase full name of the daymonday



  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint