OraFAQ Forum: Reports & Discoverer » Julian date mask & ORA-01821: date format not recognized

Home » Developer & Programmer » Reports & Discoverer » Julian date mask & ORA-01821: date format not recognized (

) 1 Vote

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

Julian date mask & ORA-01821: date format not recognized [message #90104]

Thu, 28 October 2004 10:49

Michele Razdan
Messages: 1
Registered: October 2004

Junior Member

Julian date mask & ORA-01821: date format not recognized

I am writing a new Oracle Report that requires a group by using 2 different dates (and a variance on those dates of week, month, qtr and year). In my select stmt, I have a decode for each date that must be used - see code below. The date option of "Quote Creation Date" works for all instances..no problems. The date option of "Version Creation Date" fails on the option with the Julian date mask. The other 4 (week, month, qtr and year) all work. I cannot reproduce this in SQLPlus or in Toad for Oracle. Any input is appreciated!

what I get from concurrent manager

ORA-01821: date format not recognized
ORA-02063: preceding line from NIDWMRT
==> SELECT DECODE ( : p_group_by1 , 'Quote Creation Date' , TO_CHAR ( nidw.version_creation_date , 'j' ) , 'Quote Creation Date (Week)' , TO_CHAR ( nidw.version_creation_date , 'w-mon-yyyy' ) , 'Quote Creation Date (Month)' , TO_CHAR ( nidw.version

CODE

SELECT DECODE (:p_group_by1,
'Quote Creation Date', TO_CHAR (nidw.VERSION_CREATION_DATE,'J'),
'Quote Creation Date (Week)', TO_CHAR(nidw.VERSION_CREATION_DATE,'W-MON-YYYY'),
'Quote Creation Date (Month)', TO_CHAR(nidw.VERSION_CREATION_DATE,'MON-RRRR'),
'Quote Creation Date (Qtr)', 'Q'|| TO_CHAR (nidw.VERSION_CREATION_DATE, 'Q-RR'),
'Quote Creation Date (Year)', TO_CHAR(nidw.VERSION_CREATION_DATE,'YYYY')),
DECODE (:p_group_by1,
'Version Creation Date', TO_CHAR(nidw.VERSION_CREATION_DATE,'J'),
'Version Creation Date (Week)', TO_CHAR(nidw.VERSION_CREATION_DATE,'W-MON-YYYY'),
'Version Creation Date (Month)', TO_CHAR(nidw.VERSION_CREATION_DATE,'MON-RRRR'),
'Version Creation Date (Qtr)', 'Q'|| TO_CHAR (nidw.VERSION_CREATION_DATE, 'Q-RR'),
'Version Creation Date (Year)', TO_CHAR(nidw.VERSION_CREATION_DATE,'YYYY'))

Report message to a moderator

Previous Topic:	Estimated Time for Query In Discoverer
Next Topic:	How to Group

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 09:24:47 CST 2024