hi sir
i am using to_date and to_char function with cakephp+oracle then
it is giving me letral
type error. how can i resolve it my query is below.
Error - SQL Error: ORA-01861: literal does not match format string
SELECT TO_CHAR
(TO_DATE ( TO_DATE ('2011/01/01', 'yyyy/mm/dd')
- TO_CHAR (TO_DATE ('2011/01/01', 'yyyy/mm/dd'),
'D')
+ 2,
'dd-mm-rrrr'
),
'rrrr-mm-dd'
) year_first_wk_start_rrrr,
TO_CHAR
(TO_DATE ( TO_DATE ('2011/01/01', 'yyyy/mm/dd')
- TO_CHAR (TO_DATE ('2011/01/01', 'yyyy/mm/dd'),
'D')
+ 2,
'dd-mm-rrrr'
),
'dd-mm-rrrr'
) year_first_wk_start_dmy,
TO_CHAR
( TO_DATE ( TO_DATE ('2011/01/01', 'yyyy/mm/dd')
- TO_CHAR (TO_DATE ('2011/01/01', 'yyyy/mm/dd'),
'D')
+ 2,
'dd-mm-rrrr'
)
+ 6,
'dd-mm-rrrr'
) year_first_wk_end_dmy,
TO_CHAR
(TO_DATE (SYSDATE - TO_CHAR (SYSDATE, 'D') + 2, 'dd-mm-
rrrr'),
'rrrr-mm-dd'
) cur_year_cur_week_start_rrrr,
TO_CHAR (TO_DATE (SYSDATE - TO_CHAR (SYSDATE, 'D') + 2, 'dd-mm-
rrrr')
+ 6,
'dd-mm-rrrr'
) cur_year_cur_week_end_dmy,
TO_CHAR
(TO_DATE (SYSDATE - TO_CHAR (SYSDATE, 'D') + 2, 'dd-mm-
rrrr'),
'dd-mm-rrrr'
) cur_year_cur_week_start_dmy
FROM DUAL
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
