Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help,problem query !!
Michel Cadot schrieb:
>
> "gab" <gmessad_at_tiscali.fr> a écrit dans le message de news: dom9ln$1ju$1_at_news.tiscali.fr...
> | Hello !!
> |
> | I've got a problem with a query,I would like to select some data from "
> | TbOrder"
> | table where the period date is from the 01/04/(current year) to 31/March
> | /( year +1 )
> |
> | This is my query but it's doesn't work :
> |
> | Select *
> | from TbOrder a
> | WHERE TO_CHAR(a.dat_cde,'DDMMYYYY')
> | between TO_CHAR('0104'||TO_CHAR(SYSDATE,'YYYY'),'DDMMYYYY')
> | to TO_CHAR('3103'||TO_CHAR(SYSDATE,'YYYY')+1,'DDMMYYYY')
> |
> |
> | Could you help me for this probleme !
> |
> | Thanks
>
> And to add to my previous posts in c.d.o.misc:
> - don't multipost
>
> Regards
> Michel Cadot
==
Select *
from TbOrder a
WHERE TO_CHAR(a.dat_cde,'DDMMYYYY')
between TO_CHAR('0104'||TO_CHAR(SYSDATE,'YYYY'),'DDMMYYYY')
to TO_CHAR('3103'||TO_CHAR(SYSDATE+1,'YYYY'),'DDMMYYYY')
........................................^^.HTH ( didnt test it)