Date Format for MS ACCESS SQL query - TechRepublic
General discussion
December 29, 2004 at 08:32 AM
wbarker

Date Format for MS ACCESS SQL query

by wbarker . Updated 21 years, 2 months ago

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 discussion is locked

All Comments