oracle add a year
update class_schedule set start_time = (select add_months(start_time,12*2003)from dual)
or
add_months(trunc(start_time),12*35)
Tuesday, October 09, 2007
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Achievement provides the only real pleasure in life
Google Search
My Site Search
Number of Visitors + You
My Hot Links
Blog Archive
-
▼
2007
(50)
-
▼
October
(21)
- ORA-00979: not a GROUP BY expression
- how to convert my query to stored procedure
- loop through query result and print each row in st...
- PL/SQL: ORA-01744: inappropriate INTO
- ORA-00937: not a single-group group function
- oracle sqlldr datetime value problem
- An old joke about project manager
- oracle how to random select a value out of 2 letters
- oracle add a day
- oracle add a day
- oracle get a rendom set of string value with lengt...
- oracle return a range of integer
- oracle get a random value out of a query result
- oracle update one table with values from another t...
- ORA-06550 problem in script
- oracle add an hour
- I created this, do you know what it does?
- oracle add a year
- oracle update and display datetime in Date datatyp...
- oracle generate a random date using julian dates
- using pl/sql dbms_random function for generating r...
-
▼
October
(21)
No comments:
Post a Comment