Oracle Database Discussions

Hi,

I have read a documentation which said:

The nls_date_format also allows you to display a date up to 1/100 of a second, quite precise date display:

alter session set nls_date_format = 'DD-Mon-YYYY HH24:MI:SS.FF'

But when I run it:

SQL> alter session set nls_date_format = 'DD-Mon-YYYY HH24:MI:SS.FF';

ERROR:

ORA-01821: date format not recognized

Any ideas?

Thanks