Getting the time of the entry from the Date field

hari_bk Posts: 1, Reputation: 1

New Member

Nov 23, 2004, 02:39 AM

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:

Check out some similar questions!

Date & time [ 3 Answers ]

::) How can you find out when a computer was last started and shut down.

To-date total based on current date [ 1 Answers ]

:confused: I am trying to create a forumula that will give a cumulative or "to-date" total that will exclude future months from the total. i.e. ithe point in time is August and I need to show a to-date number Through August only even though September and October are included in The...

Date and time script [ 4 Answers ]

Does anyone know a script where I program in the dates and times and from say 8th January from 5.15 until 7.30 it takes you too page2 and after that it carries on taking you to the normal page then on the next date it does the same again so say the 12th from 8am-8.45. Thanks

F-1 to H-1, what's the start date of H-1? Should be approval date or visa issue day? [ 3 Answers ]

As I mention before, I changed from F-1 to H-1 last year. I got my H-1 status in Feb 2004, but I went to my home country to get the H-1 visa stamp in August 2004. So I would like to know for counting my H-1 status, is it the date that USCIS (the Immigration) approved (which is Feb 1st), or the...

Date and time problems Win 98 [ 3 Answers ]

Hai everybody, Every time when I start my computer, the time and date are resetted back to 1999. I find this rather inconvenient so can anybody help me with a solution. I still use win 98 and on the cd there is also no time-date file as far as I know. I hope somebody can help me. Bye Boud

View more questions Search

Check out some similar questions!

Add your answer here.