trunc(sysdate) with dd-mon-rr format

I have come accross an interesting problem and wondered if anyone else has experienced it. If the nls_date_format is set to dd-mon-rr in the init.ora file, then if you "select trunc(sysdate,'DD-MON-RR') from dual", it returns the error message ora -1898 too many precision specifiers. This is also the case with YYYY and YY as the year mask. As many programs use trunc (date_column_of_some_type), this is potentially a problem.

While I would prefer to use the nls_date_format of DD-MON-YYYY, in this case I cannot. If anybody has had experience with this or could offer some insight, please email me at steve_pedersen_at_northwood.ca

Thanks. Received on Fri Jun 19 1998 - 16:28:42 CDT