Oracle

TO_CHAR function with Dates

Figo Kim 2006. 8. 30. 20:23
TO_CHAR(date, 'format_model')	

The format model:

  • Must be enclosed by single quotation marks
  • Is case-sensitive
  • Can include any valid date format element
  • Has an fm element to remove padded blanks or suppress leading zeros
  • Is separated from the date value by a comma