Re: time conversion

From: js zhang <jszhang_at_vt.edu>
Date: Wed, 17 Feb 1999 15:43:20 -0500
Message-ID: <7af9t8$o1o$1@solaris.cc.vt.edu>

Try to_date(to_char(sysdate,'DD-MON-YYYY')||

                       to_char(x),'DD-MON-YYYYHH24'
                      )

where x is the number

Jinshu

Shawn Bernard wrote in message <36CB2110.6A213069_at_mci.com>...
>I am coding in PL/SQL and i need to take a number (ranging from 0 to 23)
>and convert it to the appropriate hour. For example: 4 ==> 4:00 AM (or
>4 AM), 14 ==> 2:00 PM
>
>I can't seem to get the TO_DATE to work. Does anyone have a solution?
>
>Thanks,
>
>Shawn
>
Received on Wed Feb 17 1999 - 14:43:20 CST