Oracle Database Discussions

Hi all,

Does anyone know what the date mask is to have hundredths of seconds? I've been trolling around the
net but I can't seem to find a list of valid masks.

I need to compare date/time values in Oracle with those in another database where the fractions are stored as .nnn

At present I've got NLS_DATE_FORMAT set as 'ALTER SESSION SET NLS_DATE_FORMAT=''YYYY-MM-DD HH24:MI:SS''';

What I really need is something the lines of

'ALTER SESSION SET NLS_DATE_FORMAT=''YYYY-MM-DD HH24:MI:SS.FFF''' ;

where FFF is the fractions.

I would even be happy to have the fractions all come out as .000

Is this possible?

Thanks
Dave