Problem with a date in the query !!

From: "gab" <gmessad@xxxxxxxxxx>
Date: Sun, 25 Dec 2005 13:34:59 +0100

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

Gab

.

Follow-Ups:
- Re: Problem with a date in the query !!
  - From: William Robertson
- Re: Problem with a date in the query !!
  - From: Michel Cadot

Prev by Date: Oracle 9i tutorial or ebook
Next by Date: Re: Problem with a date in the query !!
Previous by thread: Oracle 9i tutorial or ebook
Next by thread: Re: Problem with a date in the query !!
Index(es):
- Date
- Thread

Relevant Pages

Re: Problem with a date in the query !!
... what is the query in SQL if I want to extract some date with the period ... > | TbOrder" ... complete error message helps to understand the problem ...
(comp.databases.oracle.misc)
Re: Problem with a date in the query !!
... | TbOrder" ... - "it does not work" is not a valid error message, giving the actual and complete error message helps to understand the problem ... Michel Cadot ... Prev by Date: ...
(comp.databases.oracle.misc)
Re: Help,problem query !!
... | TbOrder" ... Regards ... Michel Cadot ... Prev by Date: ...
(comp.databases.oracle.server)