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(at)psi(dot)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(at)gmx(dot)net http://yi.org/peter-e/