Hi
I have a date field in my table, and I want to extract exact time of entry. When I tried with to_char(datefield,'hh:mi:ss') Its showing same time for all the records. How can I know the exact time of the Entry of the record.

Thanks
Harikishan :confused: