Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help,problem query !!

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US