Unless you’re dealing with historical dates prior to 1970, there’s absolutely no reason your database or data set should use any time or date format that isn’t unix epoch.
Convert it to a human readable format later. Dealing with dates that aren’t epoch long ints is so annoying.