OraFAQ Forum: SQL & PL/SQL » To

Home » SQL & PL/SQL » SQL & PL/SQL » To_Date() (Oracle 10g)

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

To_Date() [message #569290]

Wed, 24 October 2012 08:00

mjaved39
Messages: 1
Registered: October 2012
Location: Lahore Pakistan

Junior Member

Dear Fellows,
i want to save 10/24/2012 to vdatefrom variable i have below line in my Script

vdatefrom := TO_DATE ('01-MON-2012 00:00:00', 'DD-MON-RRRR HH24:MI:SS');

Please help me.

Report message to a moderator

Re: To_Date() [message #569293 is a reply to message #569290]

Wed, 24 October 2012 08:08

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

it's raising the error "ORA-01843: not a valid month"

select TO_DATE ('01-MON-2012 00:00:00', 'DD-MON-RRRR HH24:MI:SS') from dual

Report message to a moderator

Re: To_Date() [message #569295 is a reply to message #569293]

Wed, 24 October 2012 08:15

Roachcoach
Messages: 1033
Registered: May 2010
Location: UK

Senior Member

Make the format mask match the input 'format'.

Report message to a moderator

Re: To_Date() [message #569297 is a reply to message #569290]

Wed, 24 October 2012 08:26

Michel Cadot
Messages: 54236
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

i want to save 10/24/2012 to vdatefrom variable i have below line in my Script

SQL> declare
  2    vdatefrom date;
  3  begin
  4    vdatefrom := to_date('10/24/2012','MM/DD/YYYY');
  5  end;
  6  /

PL/SQL procedure successfully completed.

All date format elements are described in: Datetime Format Models

Regards
Michel

Report message to a moderator

Re: To_Date() [message #569305 is a reply to message #569297]

Wed, 24 October 2012 10:05

c_stenersen
Messages: 253
Registered: August 2007

Senior Member

Quote:

'01-MON-2012 00:00:00'

Which month is "MON"?

Report message to a moderator

Previous Topic:	Syntax error
Next Topic:	NVL Function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 00:44:55 CDT 2013

Total time taken to generate the page: 0.11207 seconds