Hi
Thomas, the problem you are talking about only exists when dealing with date values without time, like "1982-01-01", not
for Timestamp values.
We could store timestamps internally as a long value, defined in the same way as that System.currentTimeMillis is
defined i.e. milliseconds since 1 Jan 1970 GMT.
Then there are no daylight saving or midnight problems, because by definition
it is unambiguous.
See here for a fuller explanation:
http://en.wikipedia.org/wiki/Unix_time
http://en.wikipedia.org/wiki/Coordinated_Universal_Time
Regards, Noel.
On 2014-05-06 07:57, Thomas Mueller wrote:
Hi,
There are various problems when using java.util.Data / java.sql.Date / Time /
Timestamp and java.util.Calendar, mainly
because of the daylight time saving changes. For example, you can't assume a
certain date (if you don't care about the
time) is "midnight", because in some timezones, for some days, midnight doesn't
exist because it's the daylight time
saving border. It's not a problem in most timezones, but it is in some.
Regards,
Thomas
On Monday, May 5, 2014, Noel Grandin <noelgran...@gmail.com
<mailto:noelgran...@gmail.com>> wrote:
I'm curious - why do we not simply store date and time in UTC format?
i.e. in milliseconds since 1 Jan 1970?
That's pretty much a universal format these days, and then we can
convert to whatever the local time zone is when we convert the value
to string.
If necessary, I could create an extra data type to represent time like this?
I know I would use it, since that's how we represent all our data.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to
h2-database+unsubscr...@googlegroups.com <javascript:;>.
To post to this group, send email to h2-database@googlegroups.com
<javascript:;>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
h2-database+unsubscr...@googlegroups.com
<mailto:h2-database+unsubscr...@googlegroups.com>.
To post to this group, send email to h2-database@googlegroups.com
<mailto:h2-database@googlegroups.com>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
