To me the biggest shortcoming in SQL 92 spec is that it thinks that
timezone is simply just a timezone offset.
It says:
"Therefore, datetime data types that contain time fields (TIME and
TIMESTAMP)
are maintained in Universal Coordinated Time (UTC), with an explicit or
implied time zone part."
The timezone of TIME is not clearly defined. It would be understandable
if you think
timezone the same as timezone offset. But invoke in java
TimeZone.getDefault().toString()
and you will see that timezone is much more than just a simple offset.
Let's say we have time 13:00:00
Let's say it is in timezone Europe/Helsinki.
What is the time in GMT?
Well that depends on what is the date.
But since it is not defined we really can not say.
So TIME is not a point in time but rather a point within a day.
And that point in day does not change when taken to Australia.
It remains the same point in a day. 13:00:00.
Could be any day. One o'clock anyday, anywhere.
So I think we don't need to be stuck too much to a standard that makes
logical errors.
- rami
On 17.6.2011 18:43, Panayiotis Vlissidis wrote:
OK, I have searched a bit and I think that the current implementation
is the correct
one according to the SQL 92 spec (as far as I can understand at least).
For anyone interested see section *4.5 Datetimes and intervals*
at http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
<http://www.contrib.andrew.cmu.edu/%7Eshadow/sql/sql1992.txt>
Excuse me for all the confusion that I may have caused
Regards,
Panayiotis
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
