Re: [help me]Date Type

richard wrote:
>
> I want to get to date type..
> I want to get to between data from 1990-01-01 to 1991-12-31.
> Example
> sql> desc s_emp;
> id number(7) not null,
> start_date date
>
> I did
> sql>select id,start_date
> sql>from s_emp
> sql>where start_date between 01-MON-90 and 31-DEC-91
>
> I unsuccess.
> help me .I hope to get to data from 1990/01/01 to 1991/12/31.
>
> please...

Try:

select id,start_date
from s_emp
where start_date between to_date('01-MON-90') and to_date('31-DEC-91')

[or]

select id,start_date
from s_emp
where start_date between '01-MON-90' and '31-DEC-91'

Yours,

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Fri Jun 02 2000 - 00:00:00 CDT