Hallo,
I am not sure how the function "quarter" should work.
I supposed it returns the quarter of an hour (1: 00-15; 2: 15-30; 3: 30-45;
4: 45:00).
But this does not work.
H2-Version: 1.4.194 dbc:h2:memLZF:test;CACHE_SIZE=65536
select quarter(parsedatetime('2017-11-10 12:03', 'yyyy-MM-dd HH:mm'))
returns "4"
select quarter(parsedatetime('2017-11-10 12:33', 'yyyy-MM-dd HH:mm'))
also returns "4"
If I change the month also the result changes:
select quarter(parsedatetime('2017-09-10 12:33', 'yyyy-MM-dd HH:mm'))
returns "3"
Is quarter for a quarter of the year?
What does it mean?
Ciao
Peter Schütt
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
