Time interval

[aamir569]

Hello..It looks to be a simple question but it has taken alot of my time: I am trying to find two value between two dates but it doesnt seem to work. It gives me result with all the values..my code is :

Date(EMAIL.DATE ) >= '2010-12-01'
AND
Date(EMAIL.DATE ) <= '2013-12-31'

I also tried :
Date(EMAIL.DATE ) = CHAR(TIMESTAMP( '2011-12-01-00.00.00'))
AND
Date(EMAIL.DATE ) >= CHAR(TIMESTAMP( '2013-03-01-00.00.00'))

[Anas Mosaad]

What is the field type of Date column in your email table?
Why don't you use between?
Make sure you convert to the correct type using to_date and to_char.