Re: [SQL] Using INDEX on date/time values // Re: how to select a time frame on timestamp rows.

On Sun, Jan 14, 2001 at 04:46:08AM +0100, Alvar Freude wrote: > Peter Eisentraut schrieb: > > > > > 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, > [...] > > select user_name from tbacct whe

[SQL] Using INDEX on date/time values // Re: how to select a time frame on timestamp rows.

Hi, Peter Eisentraut schrieb: > > > 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, [...] > select user_name from tbacct where extract(month from acct_timestamp) = 11 ... is there any way of u