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/