USING TRUN(to_date to select date between

i understand between inclusive. suprisingly, im not getting same results when select values using between in folowing statements:

statement 1:

trunc(to_date(

 

 

'01011970', 'mm/dd/yyyy') + (trandate + 2 * 3600000) / 86400000) between :atrandate and :btrandate

statement 2:

and

 

 

to_date('01011970','mm/dd/yyyy')+(trandate + 2 *3600000)/(86400000) between to_date('03-01-2010','mm-dd-yyyy') and to_date('03-31-2010','mm-dd-yyyy')

statement 3:

and trunc(

 

 

to_date('01011970','mm/dd/yyyy')+(trandate + 2 *3600000)/(86400000)) between to_date('03-01-2010','mm-dd-yyyy') and to_date('03-31-2010','mm-dd-yyyy')

suprisingly, different results these statements when select using these conditions. doing wrong??

hi,

it seemed using oracle, not sql server. if so, suggest put this question oracle forum. forum dedicated sql server reporting services. please feel free to let know if have question sql server reporting services.

thanks,
jerry

SQL Server  >  SQL Server Reporting Services, Power View