OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Adding months

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

Adding months [message #367847]

Fri, 27 October 2000 09:03

Dave McAuliffe
Messages: 1
Registered: October 2000

Junior Member

Hey

I'm trying to add a number of months to the sysdate.
All I get is ORA-01843 Not a valid Month
I'm doing this through VB BTW.

I've tried the following

add_months(sysdate, 12))
add_months(trunc(sysdate), 12))
add_months(to_date(sysdate,'DD-MM-YY'),12))

I'm pretty new to this so may be overlooking something obvious. Any help is appreciated

ta
Dave

Report message to a moderator

Re: Adding months [message #367856 is a reply to message #367847]

Mon, 06 November 2000 03:51

Indira Morishetty
Messages: 9
Registered: November 2000

Junior Member

Try doing this.
to_char(add_months(sysdate,12),'dd-mm-yy')

Thanks,
Indira Morishetty

Report message to a moderator

Previous Topic:	ORA-12154 : TNS: could not resolve service name
Next Topic:	ORA-12505 ERROR MESSAGE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 23:49:01 CST 2024