Re: What's wrong with this SQL query?

Try function TO_DATE , and use format 'DD-MON-YY'.

Albert

Paschal Mushubi wrote:

> What's wrong with this SQL?
>
> select T1.Order_Date SEP,
> T2.Order_Date OCT
> from Sales T1,
> Sales T2
> where T1.Order_Date between '01-SEP-98' and '30-SEP-98'
> and T2.Order_Date between '01-OCT-98' and '30-OCT-98'
> and T1.Dept_Number = T2.Dept_Number
>
> It returns:
>
> SEP OCT
> --- ---
> 09-22-98 09-22-98
>
> I want to see
>
> SEP OCT
> ---- ----
> 22-SEP-98 15-OCT-98
>
> What I am missing?
>
> paschal.
Received on Sun Feb 07 1999 - 10:56:46 CST