sql - Query displays null result when beyond 00:00 (24:00) -
i'm using sql server 2008 management studio data call center database, , have query login/logout time agents, every time logout value beyond 00:00 (24:00), null result. here query:
select row_date [date], logid [id], login [login], logout [logout], logoutreason [reason] db_xxxx.dbo.haglog (nolock) acd = 2 , (row_date between '2015-05-05 00:00:00' , '2015-05-05 23:59:59') , logid in (98619)
example: if logged in 06:00 pm , logged out 00:30 am, i'll null value logout.
extracted data (05/05 - 13/05):
date id login logout reason 2015-05-05 00:00:00.000 98619 1430848943 1430860539 0 2015-05-05 00:00:00.000 98619 1430860554 null null 2015-05-06 00:00:00.000 98619 1430935439 1430935856 8 2015-05-06 00:00:00.000 98619 1430935868 null null 2015-05-07 00:00:00.000 98619 1431022232 null null 2015-05-08 00:00:00.000 98619 1431108233 null null 2015-05-09 00:00:00.000 98619 1431172858 1431195952 0 2015-05-11 00:00:00.000 98619 1431367328 1431367616 8 2015-05-11 00:00:00.000 98619 1431367977 null null 2015-05-12 00:00:00.000 98619 1431453768 1431453982 8 2015-05-12 00:00:00.000 98619 1431453997 null null 2015-05-13 00:00:00.000 98619 1431540095 1431540631 8 2015-05-13 00:00:00.000 98619 1431540639 null null
i divide login/logout values 86400 right time in hours format.
Comments
Post a Comment