Can I suggest you use timestamps ('YYYY-MM-DD HH:MM:SS') for your date/time events, rather than splitting the date/time values across two columns. Also means you will no longer require the 'AM/PM' suffixes. Please refer to https://www.sqlite.org/lang_datefunc.html