OraFAQ Forum: SQL & PL/SQL » Sysdate + 10 more Seconds

Home » SQL & PL/SQL » SQL & PL/SQL » Sysdate + 10 more Seconds

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

Sysdate + 10 more Seconds [message #23342]

Tue, 03 December 2002 07:27

Viswa
Messages: 8
Registered: October 2002

Junior Member

Hi,

I have a table like below;

SQL> desc test;
Name Type
------------------------
BDATE DATE

I want to insert a record like sysdate+10 more secods.

ie) if the sydate is 03-DEC-0209:12:11 then i want to insert 03-DEC-0209:12:21

Your help highly appreciated.

regards
Viswa

Report message to a moderator

Re: Sysdate + 10 more Seconds [message #23343 is a reply to message #23342]

Tue, 03 December 2002 07:52

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

How about saying,

Select sysdate+to_date(sysdate,'SS') from dual ;
Franks i am writing this spontaneously, please do some permutations and combinations..
sai

Report message to a moderator

Re: Sysdate + 10 more Seconds [message #23346 is a reply to message #23342]

Tue, 03 December 2002 17:22

Barbara Boehmer
Messages: 9094
Registered: November 2002
Location: California, USA

Senior Member

INSERT INTO test (bdate)
VALUES (SYSDATE + 10 / (60 * 60 * 24));

Report message to a moderator

Previous Topic:	Diff. between 'IS' & 'AS' key words while creating the Function,Procedure..
Next Topic:	getting rowcount as part of the select field

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 21:49:05 CDT 2024