Re: [SQL] datediff function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pham, Thinh" <tpham(at)mail(dot)priority(dot)net>
Cc: "'pgsql-sql(at)postgreSQL(dot)org'" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] datediff function
Date: 1999-08-17 13:34:21
Message-ID: 15494.934896861@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Pham, Thinh" <tpham(at)mail(dot)priority(dot)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

Browse pgsql-sql by date

  From Date Subject
Next Message Pham, Thinh 1999-08-17 14:37:04 RE: [SQL] datediff function
Previous Message Herouth Maoz 1999-08-17 13:28:44 RE: [SQL] datediff function