find user lock account timings

[midora]

Hi all,

How can i find out the time the user account got locked? I can get date but how can i get the time?

Please guide!!

thanks

[vnktummala]

Set nls_date_format ...

alter session set nls_date_format='dd-mon-yy hh24:mi:ss';

select username, lock_date from dba_users where username='XXXX';

Thanks,