From: Rick James (rjamesyahoo-inc.com)
Date: Wed Jun 20 2012 - 12:22:36 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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:sb_akarmarkaryahoo.com]
> Sent: Wednesday, June 20, 2012 2:39 AM
> To: mysqllists.mysql.com
> 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]