Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Posts
    8

    Unanswered: Need help on Oracle date fomat

    Hi,

    What date format should I use in order to get output as

    Feb 2 2009 8:30PM.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Code:
    SQL> select to_char(sysdate, 'Mon d yyyy hh:miam') from dual;
    
    TO_CHAR(SYSDATE,'M
    ------------------
    Feb 3 2009 12:52PM
    
    SQL>

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    This can easily be looked up in the manual:
    http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm#i34924

Posting Permissions

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