Re: add date to time

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 17 Oct 2001 00:02:57 +0200
Message-ID: <tspcc5ea58ts1b_at_corp.supernews.com>

"sgupta" <sugandha_g_at_yahoo.com> wrote in message news:62deede6.0110161257.77056370_at_posting.google.com...
> Hi
>
> I have a field like this :
>
> 10/16/2001 10:40:56 AM
>
> I want it to adjust it by adding 5h:02m:31s to compensate for diff
> times on 2 diff machines.
> How do i do it. I am new to oracle and no clue how to
>
> -sg

you can add a time when you convert it to a fraction of a day.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Wed Oct 17 2001 - 00:02:57 CEST

This message: [ Message body ]
Next message: Jining Han: "Portal30 home page gives 404"
Previous message: Sheldon Wang: "where can I download Developer 2000 for Windows NT"
In reply to: sgupta: "add date to time"
In reply to sgupta: "add date to time"
Next in thread: Cong Tang: "Re: Getting Initialization and shutdown in progress error msg while connecting with sqlplus"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message