Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I add time to time. 1

Status
Not open for further replies.

bandarna

Programmer
Jan 2, 2003
122
US
How can I add time to time.

e.g. I want to add 40 mi to sysdate.

select sysdate + 40 from dual;
how can I do this?
Even If convert my date like 20030311000000 forma and add it is going to infinite

select FGNR_EIN,to_Char(d_f2_st50)+50 from orders
where FGNR_EIN = 'LT42355'


FGNR_EI TO_CHAR(D_F2_ST50)+50
------- ---------------------
LT42355 2.003E+13

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top