query and date format

[vnktummala]

set the nls_date_format for the session and try the query.

alter session set nls_date_format='YYYYMMDD';

Thanks,