Oracle

TO_CHAR function with Dates

Figo Kim 2006. 8. 30. 20:23
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
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




'Oracle' 카테고리의 다른 글

General Functions  (0) 2006.08.30
TO_CHAR function with Dates  (0) 2006.08.30
Date Functions  (0) 2006.08.30
Date Functions  (0) 2006.08.30
Using the && Substitution variable  (0) 2006.08.29