On Thu, Dec 07, 2023 at 10:18:44PM -0600, Nicholas Geovanis wrote: [...] > All of these considerations are what brought Oracle to create a proprietary > "datetime" datatype and use it to store all "real" dates/times. If you need > a different format for display purposes or a human readable column, you can > extract it and do that. But the internal representation will be driven by > other needs. > YMMV :-) If anyone is looking for inspiration, I think what PostgreSQL does is one of the best and most complete implementations I've seen. Cheers -- t
Attachment:
signature.asc
Description: PGP signature