当天:Select * From GG_DTXX a Where trunc(fbsj)= trunc(Sysdate)
当月:Select * From GG_DTXX a Where to_char(fbsj,'yyyymm') = to_char(Sysdate,'yyyymm')
当年:select * from GG_DTXX t where t.fbsj >=trunc(sysdate,'YYYY') and t.fbsj<=add_months(trunc(sysdate,'YYYY'),12)-1
当月:Select * From GG_DTXX a Where to_char(fbsj,'yyyymm') = to_char(Sysdate,'yyyymm')
当年:select * from GG_DTXX t where t.fbsj >=trunc(sysdate,'YYYY') and t.fbsj<=add_months(trunc(sysdate,'YYYY'),12)-1