Postgres Pro
Downloads
Home   >   mailing lists

Searching datetime infos - Mailing list pgsql-novice

From Boris
Subject Searching datetime infos
Date
Msg-id 10127198909.20001230020922@x-itec.de
Whole thread Raw
List pgsql-novice
Tree view 
Hello,

I am searching general informations about datetime calculations in
PGSQL. In the meantime I found a lot of interesting constructions like

 ... age('now',datum) > timespan('90 days'::reltime) ...

 or

 ... 'now'::datetime - '90 days'::timespan ...


 Are they anywhere any dox about this things in genereal????


--
Boris

pgsql-novice by date:

Previous
From: Charles Curley
Date:
Subject: Re: date_part function
Next
From: Thomas Stepleton
Date:
Subject: newbie sql question re: subqueries, order by, and limit