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>
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.ruReceived on Thu Feb 24 2000 - 09:42:09 CET