Re: developer 2000 adding hours to date

From: Valeri Sorokine <vsorokin_at_dd.ru>
Date: Thu, 24 Feb 2000 11:42:09 +0300
Message-ID: <38B4EEE1.3633CE71_at_dd.ru>


Hi Sharma,

It seems that you are trying to use DATE format, but you'd better try to use DATETIME format instead...

Hope that helps.

ssharma24_at_my-deja.com wrote:
>
> I am trying to add a date (with a given time in HH:MI format mask)
> and add some hours to this text item and put it in another item
> in the same format (date and time)..the problem I am having is that
> it does calculate the correct date but time stays like 12:00.
> This query does work in sql*plus.
> Both fields are date type..
> appreciate your help.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

-- 
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru   ; http://www.dd.ru
Received on Thu Feb 24 2000 - 09:42:09 CET

Original text of this message