We are storing customer birthdays in a date column. When we query the API for a specific customer, the date comes preformmated not as a date but as a long number, so today’s date becomes 1661817600 (not August 30, 2022). What exactly is that number? I though at first this was a unix date/time, but when we convert today’s date to unix, we don’t get that, so clearly the dates are using some other transform. So how exactly how are dates stored in the database? We need to query something based on today’s date, i.e. if today’s date is someones birthday, do this…
That number is a unix timestamp in seconds. In this case, 1661817600 is August 30, 2022 00:00:00 GMT.