Question: I am using MSSQL using the T-SQL
DATEADD function to add a duration to an existing date.
In
this example, I am adding a duration expressed in seconds to a
existing DATE datatype:
current_end_time := DATEADD(second, current_duration/10,
current_start_time)
What is the equivalent of DATEADD for adding Oracle dates?
Answer: Above you are adding the seconds
in your current_duration to an existing date. Oracle is far
more powerful than MSSQL, and there are several ways to replicate
this functionality:
- Write your own
DATEADD function. In Oracle PL/SQL, you
can write
autonomous functions that become instantly available as any other
built-in function. This makes Oracle infinitely extensible
and any TSQL date addition function can be replicated in PL/SQL.
- Use the add_months function in Oracle, and use
simple math to convert the month
value to seconds.
- You can also use the Oracle interval function
See here for more
Oracle
date arithmetic examples
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
