Ask Me Help Desk - Getting the time of the entry from the Date field

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)

- MySQL (https://www.askmehelpdesk.com/forumdisplay.php?f=442)

- - Getting the time of the entry from the Date field (https://www.askmehelpdesk.com/showthread.php?t=6350)

Getting the time of the entry from the Date field

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:

All times are GMT -7. The time now is 06:08 AM.