Re: Help,problem query !!

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 25 Dec 2005 17:29:03 +0100
Message-ID: <43aec8cf$0$14552$626a14ce@news.free.fr>

"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 Received on Sun Dec 25 2005 - 10:29:03 CST