I have some date for example July 9, 2018 that I am keeping in my dynamodb table. But I actually have two dates for that day, July 9 2018 AM and July 9 2018 PM. I need to convert each of those into a different number. They can't be the exact same. I thought about using time(). What would be perfect if I could somehow generate a date like July 9, 2018 0800 (which is 8AM) and July 9 2018 1400 (which is 2PM) and then convert each date-time into a number of seconds since the epoch.
The reason to do this is that I am using dynamodb and I want to get all the records between Jan 1st 2018 and Dec 31 2018. But as i said i am not allowed to have two records with exactly the same value, and I don't think it can compare dates, just numbers or strings.
Any ideas?
proof that an old dog can learn new tricks