OraFAQ Forum: SQL & PL/SQL » how to add hours to date

Home » SQL & PL/SQL » SQL & PL/SQL » how to add hours to date

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to add hours to date [message #185821]

Thu, 03 August 2006 14:58

dhanisetti
Messages: 7
Registered: July 2006

Junior Member

Hi Experts,

I want to add one hour to date which takes input from user

I used the below query

select &UserDate + 1/24 from dual

It is working but not giving the same result as the following query gives.

select sysdate + 1/24 from dual

Please help on this.

Thanks
Dhani

Report message to a moderator

Re: how to add hours to date [message #185825 is a reply to message #185821]

Thu, 03 August 2006 15:15

scottwmackey
Messages: 515
Registered: March 2005

Senior Member

Try this

select to_date('&UserDate', 'YOUR_FORMAT') + 1/24 from dual

Report message to a moderator

Re: how to add hours to date [message #185829 is a reply to message #185825]

Thu, 03 August 2006 15:39

dhanisetti
Messages: 7
Registered: July 2006

Junior Member

Hi Scott,

The above query is giving error.

Please let me know if any other options

Thanks in advance,
Dhani

Report message to a moderator

Re: how to add hours to date [message #185834 is a reply to message #185829]

Thu, 03 August 2006 16:22

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

And how are we supposed to know WHICH ERROR did you get? Was it, perhaps, ORA-01821?

By the way, Scott's suggestion works fine on my Oracle 10g.

SQL> alter session set nls_date_format = 'dd.mm.yyyy. hh24:mi';

Session altered.

SQL> SELECT
  2    SYSDATE now,
  3    SYSDATE + 1/24 now_plus_1_hour,
  4    TO_DATE('03.08.2006. 23:20',
  5            'dd.mm.yyyy. hh24:mi') + 1/24 approx_now_plus_1_hour
  6  FROM dual;

NOW                  NOW_PLUS_1_HOUR   APPROX_NOW_PLUS_1
-------------------- ----------------- -----------------
03.08.2006. 23:21    04.08.2006. 00:21 04.08.2006. 00:20

SQL>

Report message to a moderator

Previous Topic:	how to print our name 5 times rowwise using dual table
Next Topic:	Duplicate emails, but need to isolate column value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 23 23:56:06 CDT 2025