I am passing in the name of a file and the time of day it was accessed.
Like this to_char('" & thedate & "','YYYY-MM-DD HH24')
I am trying to count how many times the file was viewed on an hourly basis.
The time show up like this 2000-08-15 2:05:33 PM
will the group by to_char('" & thedate & "','HH24') work?
I have been trying to get this query to work since monday.
Thanks in advance.
