Discussion Locked

Date Format for MS ACCESS SQL query

0 helpful

3 replies

by wbarker Dec 29, 2004 last reply Apr 18, 2005

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

WHERE Month(hagent.STARTTIME) = 8

Poster rated this answer.

This question was closed by the author

This discussion is closed to new replies.