Hi Jorez,

I have used CAST and work fine.

SELECT .......
WHERE
( DAT_FAT BETWEEN CAST('01/01/2002' AS DATE) AND CAST('31/12/2002' AS
DATE))

> ----- Mensagem original -----
> De: Jorez A. Nasato [SMTP:jorez@...]
> Enviada em: sexta-feira, 27 de dezembro de 2002 13:59
> Para: ib-support@yahoogroups.com
> Assunto: Re: [ib-support] Select with dates
>
> I have tried it, but I wold like to know if there was some problem tha I
> didn't know.
>
> Thanks.
>
> ----- Original Message -----
> From: "Helen Borrie" <helebor@...>
> To: <ib-support@yahoogroups.com>
> Sent: Friday, December 27, 2002 11:39 AM
> Subject: Re: [ib-support] Select with dates
>
>
> > At 10:45 AM 27/12/2002 -0300, you wrote:
> > >Hi!
> > >
> > >I'm trying to do the folow select:
> > >select * from table where data between '12/01/2002' and '12/23/2002'
> > >
> > >And in the table I have:
> > >code------data--------------text
> > >1 23/12/2002 xxxxxxxx
> > >2 24/12/2002 yyyyyyyyy
> > >
> > >So, when I execute the select, its returns null, could someone help,
> I'm
> > >using FB and the database was created with dialect 1.
> >
> > Dialect 1 dates are timestamps. This query won't return the first row
> if
> > its time portion is greater than '00:00:00'. Change the WHERE clause to
> one
> > of the following:
> >
> > where data between '12/01/2002' and '12/23/2002 23:59:59.9999'
> >
> > or
> >
> > where data >= '12/01/2002' and data < '12/24/2002'
> >
> > heLen
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>