how to convert date of birth in (dd-mon_yyyy) this format?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Irfan iffi
    New Member
    • May 2013
    • 1

    how to convert date of birth in (dd-mon_yyyy) this format?

    how to convert date of bith in (dd-mon-yyyy) this formate ? plz kindly help me

    How to convert date of birth in in years in oracle form 6i
    Last edited by acoder; May 27 '13, 12:15 PM.
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    If you're trying to convert a string to a date format, use the TO_DATE function. If you're trying to extract a part of a date in a certain format, use the TO_CHAR function.

    Your question is unclear as to what you're trying to do.

    Comment

    • Beigirad
      New Member
      • May 2013
      • 7

      #3
      hi there
      your question is not clear.

      Comment

      Working...