From: Herouth Maoz <herouth@oumail.openu.ac.il>
To: Pham, Thinh <tpham@mail.priority.net>
To: 'pgsql-sql@postgreSQL.org' <pgsql-sql@postgreSQL.org>
Subject: RE: [SQL] datediff function
Date: Tue, 17 Aug 1999 16:28:44 +0300
Message-ID: <l03130302b3df13be6b8f@[147.233.159.109]> (raw)
In-Reply-To: <551413BBBB03D111BF880060B01AACCE139F34@home.priority.net>
At 16:18 +0300 on 17/08/1999, Pham, Thinh wrote:
> What happen if i just want to compare using minute only or hour only instead
> of day? Is there a function to do that or is postgres only work in day?
No problem, just write 'now'::datetime - '6 hours'::timespan. Or some such.
Please read about the datetime and timespan types in the user guide.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: herouth@oumail.openu.ac.il, tpham@mail.priority.net
Subject: RE: [SQL] datediff function
In-Reply-To: <l03130302b3df13be6b8f@[147.233.159.109]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox