Unanswered: Getting time of the entry from Date field
I have a date field in my table, We use forms for data entry. and format mask is DD-MM-RRRR 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.