Is anyone out here can give some advice?
i have a table with a timestamp field.
i should know if there is records for the particular year and month
so i need a query like (in MySQL it was very simple, but i should move to
SELECT something FROM mytable WHERE MONTH('timestamp_field')=07
AND YEAR('timestamp_field')=2000 LIMIT 1;
So, i am looking for date/time functions:
SELECT * FROM table WHERE date_part('year',timestamp 'timestamp_field') =
but it doesn't work...(ERROR: Bad abstime external representation
may be i need subselect or abstime(timestamp) function??
I suppose it's a lame q, but i cannot solve it today...
pgsql-novice by date
|Next:||From: James Hall||Date: 2000-07-07 18:07:08|
|Subject: User attributes|
|Previous:||From: ERIC Lawson - x52010||Date: 2000-07-07 17:19:10|
|Subject: Re: order by accents?|