Hello All.
I have a table that has entries for specific times of the day. I want to compare the current time to that table and process records based on whether the current time is between the min and max times for a day. There can be multiple entries and I am not sure of how to do this. Example:
I want to select the record that falls between 12:05:00 PM and 3:05:00 PM based on the current time.
Any help will be greatly appreciated.
I have a table that has entries for specific times of the day. I want to compare the current time to that table and process records based on whether the current time is between the min and max times for a day. There can be multiple entries and I am not sure of how to do this. Example:
I want to select the record that falls between 12:05:00 PM and 3:05:00 PM based on the current time.
Any help will be greatly appreciated.