Re: first of the year

On Tue, 6 Jan 2004 21:35:48 -0700, "Shawn" <spedwards_at_qwest.net> wrote:

>I have the below script. Every year we change the date (dpdate) in it
>manually so it reflects the beginning of the current year.
>I just haven't been able to figure it out. Any suggestions would be greatly
>appreciated.
>
>select decode(pull_level,'G','UNWRAPPED','S','WRAPPED') x, ga_id,
> prov_company,sum(amount) gloss
>from std_invopt,event,acctg_txn_acty
>where acctg_txn_acty.ev_id = event.id
> and std_invopt.id = acctg_txn_acty.sdio_Id
> and trunc(dpdate) >= '01-JAN-04'
>GROUP BY
>decode(pull_level,'G','UNWRAPPED','S','WRAPPED'),ga_id,prov_company
>/
>
>
>Thanks
>

>= trunc(sysdate,'YEAR')

--
Sybrand Bakker, Senior Oracle DBA