Roy> It would be
Roy> INTERVAL '1 1' DAY TO HOUR
Actually, it would be any one of the following:
INTERVAL '1 1' DAY TO HOUR
INTERVAL '1 1:00' DAY TO MINUTE
INTERVAL '1 1:00:00' DAY TO SECOND
INTERVAL '25' HOUR
INTERVAL '25:00' HOUR TO MINUTE
INTERVAL '25:00:00' HOUR TO SECOND
INTERVAL '1500' MINUTE
INTERVAL '1500:00' MINUTE TO SECOND
INTERVAL '90000' SECOND
all of which are equivalent to the postgres interval
INTERVAL '1 day 1 hour'
but all of them have (in ANSI SQL) disitinct data types.
At this point you may decide that ANSI intervals are (to put it
politely) somewhat overcomplex... :-)
-roy
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
