Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2013
    Posts
    15

    Question Unanswered: Getting the Month Name from Numeric field showing as 20130918

    How would I get the Month name of September from a Numeric(8,0) that displays the date as 20130918.

    I have searched for sometime and tried many things and I'm not gettting anywhere. Any help would be appreciated.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    One way might be
    (1) Convert the numeric value to date(or timestamp) datatype(e.g. by using TO_DATE function).
    (2) Then apply MONTHNAME function.

  3. #3
    Join Date
    Jun 2013
    Posts
    15
    Yes, that did the trick, thanks very much for your advice tonkuma. :-)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •