Help,problem query !!

From: gab <gmessad_at_tiscali.fr>
Date: Sun, 25 Dec 2005 15:17:21 +0100
Message-ID: <dom9ln$1ju$1@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 Received on Sun Dec 25 2005 - 08:17:21 CST