General discussion

Locked

Date Format for MS ACCESS SQL query

By wbarker ·
I want to look at records that were created during the 8 AM hour over the course of the past 90 days. In Oracle SQL I would write:

WHERE to_char(hagent.STARTTIME,'HH24') = '08'

All I need is to translate this into MS Access lingo, but I know nothing about Access.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums