Re: how to select a time frame on timestamp rows.

Peter Eisentraut wrote:
Thanks Peter for the answer, so i assume i can also do
select user_name from tbacct where extract(month from acct_timestamp) =
11 and extract(year from acct_timestamp) = 2000 ...


> 
> 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/