Postgres Pro
Downloads
Home   >   mailing lists

Re: how to select a time frame on timestamp rows. - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: how to select a time frame on timestamp rows.
Date
Msg-id Pine.LNX.4.30.0101140208531.965-100000@peter.localdomain
Whole thread Raw
In response to how to select a time frame on timestamp rows.  (bartschm@psi.com)
List pgsql-sql
Tree view 
bartschm@psi.com writes:

>     today i was trying to perform a query on a database using a time stamp
> field, i need to get all records which belong to year 2000, month 11,
> is there any other way to doit, or is this the pgsql way?  , actually
> i'm using a query like this:
> select User_Name from tbacct where acct_timestamp like '2000-11%' group
> by User_Name;

select user_name from tbacct where extract(month from acct_timestamp) = 11 ...

(SQL compliant)

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

pgsql-sql by date:

Previous
From: bartschm@psi.com
Date:
Subject: how to select a time frame on timestamp rows.
Next
From: bartschm@psi.com
Date:
Subject: Re: how to select a time frame on timestamp rows.