incorrect results with java.sql.Timestamp

[sure919]

Hi,

 

I am trying to create a SQL report to display the record if they fall between the specified date&time range(ex: Nov 21, 2003 11 30 0 and Nov 21, 2003 14 30 0)

 

i m confused why the preceeding value is getting displayed in the report (ex: its displaying the record of Nov 21, 2003 11 18 ).

 

my DB is SQL Server, and the datatype that I am using is java.sql.Timestamp in iReport

 

Please help me on this.

 

Thanks, in advance

Sure.