Re: Compare date and timestamp using sql

[Maur�cio Albuquerque]

Thanks Denver and Kevin.

I used the solution:

select * from Table where FieldDateTime <= DateParameter_'23:59:59', and it
worked.

and in the case I have DateParameter and TimeParameter I used:

select * from Table where FieldDateTime <= TO_CHAR( DateParameter,
'YYYY-MM-DD' )_
{ fn CONVERT( TimeParameter, SQL_VARCHAR ) }, and it worked.

Thanks Denver and Kevin, and sorry for my bad english.

Mauricio.