[SQL] 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 ... > > [EMAIL PROTECTED] writes: > > > today i was trying to perform a query on a databa

[SQL] how to select a time frame on timestamp rows.

Hello, 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_tim