| Subject | Re: group by week |
|---|---|
| Author | james_027 |
| Post date | 2003-10-18T08:02:10Z |
Iam sorry ... but iam getting this error after I execute this one...
select "ItemID", f_weekofyear(cast("ProduceDate" as date)), sum
("Qty") as "Qty"
from "produce" m
where "ProduceDate" >= '9/1/2003'
group by f_weekofyear(cast("ProduceDate" as date))
Invalid token.
invalid request BLR at offset 96.
function F_WEEKOFYEAR is not defined.
module name or entrypoint could not be found.
select "ItemID", f_weekofyear(cast("ProduceDate" as date)), sum
("Qty") as "Qty"
from "produce" m
where "ProduceDate" >= '9/1/2003'
group by f_weekofyear(cast("ProduceDate" as date))
Invalid token.
invalid request BLR at offset 96.
function F_WEEKOFYEAR is not defined.
module name or entrypoint could not be found.