You're thinking of creating a custom storage format for anything related to time. Don't.
-
i gather you have just had some kind of experience :) would you ever make a custom postgres type?
Postgres stores time as an i64 for seconds and a u32 for subsecond nanos as an offset from a known time. Why would you want anything else?
-
-
Does those work for storing a time of day (e.g. 6:35 PM) that's not connected to a date?
-
Time is stored as an i64 which is microseconds since midnight.
- 2 more replies
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.