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



Comments

Post a Comment

Popular posts from this blog

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -cred...
Read more

set datagrid current record to inserted record

i have master detail page datagrid , dataform. there text box users can enter client reference number. if th reference bumber not found, child window pops uo d ataform insert. want when new record inserted, , child window closed, current record in datagris should set inserted record.. how possible private sub addnewclient_closed(sender object, e eventargs) dim clients cwclientadminadd = sender dim dd domaindatasource = ria_clientselection if not clients.newtbcbi_client nothing dd.dataview.add(clients.newtbcbi_client) dd.submitchanges() else dd.cancelsubmit() end if end sub private sub ria_clientselection_submittedchanges(sender object, e system.windows.controls.submittedchangeseventargs) if e.haserror messagebox.show(e.[error].tostring(), "submit error", messageboxbutton.ok) e.markerrorashandled() else me.dgclientsearch.itemssourc...
Read more