Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] datediff function - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] datediff function
Date
Msg-id 15494.934896861@sss.pgh.pa.us
Whole thread Raw
In response to RE: [SQL] datediff function  ("Pham, Thinh" <tpham@mail.priority.net>)
List pgsql-sql
Tree view 
"Pham, Thinh" <tpham@mail.priority.net> writes:
> 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?

See date_part().
        regards, tom lane

pgsql-sql by date:

Previous
From: Herouth Maoz
Date:
Subject: RE: [SQL] datediff function
Next
From: "Pham, Thinh"
Date:
Subject: RE: [SQL] datediff function