| From: | "pauLSiew" <paul(at)mqplayharder(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Date problem |
| Date: | 2002-02-21 02:44:30 |
| Message-ID: | a51mv0$1rra$1@jupiter.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm using pgsql with php, and my query below will retrieve employee's
monthly sales total,
"select sum(salesTotal) from ocf where employeeNo='0123' AND orderDate like
'%$month $year %'" // i put % infront to ignore day, and % at the back to
ignore the time (because i'm using timestamp with timezone), then i shall
get particular month's records.
$month = Feb
$year = 2002
But i cant retrieve the data, if i take out the $year, it works...but i
need the year to identify the records.
it works when i do a direct sql query to the pgsql through pg-admin, the
query are like this,
select grand_total,ocf_no,date from ocf where date like '2002-01%' order by
date;
i really confused with the date format......
Anybody got any solution or better idea, pls reply! THANK YOU
Regards,
pauL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Harr | 2002-02-21 03:43:41 | Re: entering empty value |
| Previous Message | Hugo Coolens | 2002-02-21 02:25:28 | batch file |