I’m trying to extract the hour from a datetime column. When I use
datetime_format(field('date'), 'HH') it seems to extract the AM time of a 24hr entry.
Any ideas or a better way to extract the hour?
My end goal is to have a column say true or false if the time is between 00:00 and 06:00.