>1. Use to_date('10:10','HH:mi') to store the time in the Oracle
>database. This will insert the current date in the date portion but you
>can retreive the time using to_char(date_field 'HH:mi');
>
>2. Use to_date('01/01/0001','MM/DD/YYYY') + :hour/24 + :minute/1440 to
>store the time in the Oracle database. This will allow you to add/subtract
>time and get the time difference in fractional days. To retrieve the time
>use to_char(datefield, 'HH:mi').
>
>Hope this helps.
>
>Janet.
>
>At 09:01 AM 7/13/2004 -0400, you wrote:
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
