Thanks Rick for your reply, Here i am asking about logic to perpare query or whole query itself.
--Anupam ________________________________ From: Rick James <[email protected]> To: Anupam Karmarkar <[email protected]>; "[email protected]" <[email protected]> Sent: Wednesday, 20 June 2012 10:52 PM Subject: RE: Need Query Help http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff and SEC_TO_TIME()/3600 > -----Original Message----- > From: Anupam Karmarkar [mailto:[email protected]] > Sent: Wednesday, June 20, 2012 2:39 AM > To: [email protected] > Subject: Need Query Help > > Hi All, > > I need query help for following table struture, where we need to > calculate login duration of that employee for give period. > > Example table > > > EmployeeID LoginTime LogoutTIme > > 101 2012-05-01 10:00:00 2012-05-01 12:30:00 > 102 2012-04-31 23:00:00 2012-05-02 05:00:00 > > 103 2012-05-01 14:00:00 NULL > 104 2012-05-02 00:10:00 2012-05-02 05:00:00 > > > I tried to fit all scenario in above table, Consider NULL as yet to > logout > > > How would i calcuate Employee and it Login duration for period say from > 2012-05-01 08:00:00 to 2012-05-01 22:00:00 > > > --Anupam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
