Quote:
Originally Posted by kovidgoyal
I have to say that accepting dates without timezones, but not dates+times without timezones is one of the more asinine things I have seen.
|
Well, if you have a date without time zone you have the precise time +/- 24 hours. With timezone you have the precise time +/- 12 hours. So adding the time zone only makes the reference twice as precise.
Adding a time (hours:minutes) without time zone to a date only gives you the time to +/-12 hours. Then adding a time zone gives you the time +/- 30 seconds. So in this instance adding a time zone makes the reference 1440 times as precise.
Perhaps this explains why I've never seen a date given with a time zone....