I have a query that I need to group by the year of a date that is stored as a string , i.e. 20080630.
SELECT WGMAHIST_TIMEDTY.TDYLCL, WGMAHIST_TIMEDTY.TDYTDT, sum(WGMAHIST_TIMEDTY.TDYFND) AS Hrs
FROM WGMAHIST_TIMEDTY
WHERE WGMAHIST_TIMEDTY.TDYSSN=123456789
group by WGMAHIST_TIMEDTY.TDYTDT, WGMAHIST_TIMEDTY.TDYLCL
I know that this can be done but How?
Thanks
SELECT WGMAHIST_TIMEDTY.TDYLCL, WGMAHIST_TIMEDTY.TDYTDT, sum(WGMAHIST_TIMEDTY.TDYFND) AS Hrs
FROM WGMAHIST_TIMEDTY
WHERE WGMAHIST_TIMEDTY.TDYSSN=123456789
group by WGMAHIST_TIMEDTY.TDYTDT, WGMAHIST_TIMEDTY.TDYLCL
I know that this can be done but How?
Thanks