I have a create date field that contains a date and timestamp. In my script , I use the statement below to take out the time stamp and merge all entries with the same day . This allows me to select all of a certain day/range of days easily. I am wondering if there is a similar statement that I can use to get rid of the date and merge the timestamps by hour. I would then be able to say, regarless of date, give me entries from this time to this time.
date(daystart(createdate),'MM/DD/YY') as CreateDayGL,
