Hi I have a time stamp looking like "09/01/2003 18:45:32".
All I want is to do a query based on the date.
I am creating a query which tracks users views but as the time is in there it counts a 'hit' each time somebody views
the page for that time, rather than the day. This means i
have to count the hits up from the table...I could do with
a quicker solution!! Perhaps you can help.
Here's my QUERY
Select count(*) as hits, page,page_id,datetime from usertrack
Where page= "/news_article.cfm"
Group by datetime
Many Thanks
All I want is to do a query based on the date.
I am creating a query which tracks users views but as the time is in there it counts a 'hit' each time somebody views
the page for that time, rather than the day. This means i
have to count the hits up from the table...I could do with
a quicker solution!! Perhaps you can help.
Here's my QUERY
Select count(*) as hits, page,page_id,datetime from usertrack
Where page= "/news_article.cfm"
Group by datetime
Many Thanks