DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Function required

  1. 06-12-2002, 12:07 PM #1
    jayam
    jayam is offline Junior Member
    Join Date
    Jun 2002
    Posts
    1
    Hi
    I need a function that should return as follows
    Input Return Value
    8:00 08:00
    08:00 08:00
    8:00PM 20:00
    08:00PM 20:00
    8:00 AM 08:00
    08:00 AM 08:00
    others Null

    Thanx in advance
    Regards
    Jayam
    Reply With Quote Reply With Quote
  2. 06-12-2002, 08:40 PM #2
    skid
    skid is offline Junior Member
    Join Date
    Apr 2002
    Location
    Philippines
    Posts
    77
    you can use the 'hh24:mm' format masks like:
    SQL> select to_char(sysdate,'hh24:mm') from dual;

    TO_CH
    -----
    08:06

    hth.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules

Click Here to Expand Forum to Full Width