diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-07-20 16:42:32 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-07-20 16:42:32 +0000 |
| commit | db05f4a7eb6c80c67c25ca9d28be825b99ed3553 (patch) | |
| tree | dee67dee9058a0243609c838c6be521143d23f3b /doc/src | |
| parent | 826604f9e61c233c4229a3eb4d1ee3945691ee1b (diff) | |
| download | postgresql-db05f4a7eb6c80c67c25ca9d28be825b99ed3553.tar.gz postgresql-db05f4a7eb6c80c67c25ca9d28be825b99ed3553.zip | |
Add 'day' field to INTERVAL so 1 day interval can be distinguished from
24 hours. This is very helpful for daylight savings time:
select '2005-05-03 00:00:00 EST'::timestamp with time zone + '24 hours';
?column?
----------------------
2005-05-04 01:00:00-04
select '2005-05-03 00:00:00 EST'::timestamp with time zone + '1 day';
?column?
----------------------
2005-05-04 01:00:00-04
Michael Glaesemann
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 9fd6ed61f8e..43f720ae10f 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.267 2005/07/18 22:34:14 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.268 2005/07/20 16:42:29 momjian Exp $ PostgreSQL documentation --> @@ -5145,6 +5145,22 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); </row> <row> + <entry><literal><function>justify_hours</function>(<type>interval</type>)</literal></entry> + <entry><type>interval</type></entry> + <entry>Adjust interval so 24-hour time periods are represented as days</entry> + <entry><literal>justify_hours(interval '24 hours')</literal></entry> + <entry><literal>1 day</literal></entry> + </row> + + <row> + <entry><literal><function>justify_days</function>(<type>interval</type>)</literal></entry> + <entry><type>interval</type></entry> + <entry>Adjust interval so 30-day time periods are represented as months</entry> + <entry><literal>justify_days(interval '30 days')</literal></entry> + <entry><literal>1 month</literal></entry> + </row> + + <row> <entry><literal><function>localtime</function></literal></entry> <entry><type>time</type></entry> <entry>Time of day; see <xref linkend="functions-datetime-current"> |