I don’t really get why people use any time other than ms/seconds since the epoch for anything other than displaying that time to the end user. Having time just be a single number with no time zone shenanigans makes writing logic like that so much easier.
I don’t really remember SQL, does it prevent you from using a range of values? I can understand why leap seconds would be an issue.