Re: [GENERAL] work hour calculations

2007-09-09 Thread Filip Rembiałkowski
2007/9/9, novice <[EMAIL PROTECTED]>: > > > > The result I'm expecting for the above to be > > > > > > > >notification_time| finished_time | actual > > > > ++- > > > > 2007-07-06 15:50:00+10 | 2007-07-09 07:10:00+

Re: [GENERAL] work hour calculations

2007-09-08 Thread novice
On 07/09/2007, Filip Rembiałkowski <[EMAIL PROTECTED]> wrote: > 2007/9/5, Raj A <[EMAIL PROTECTED]>: > > correction: > > > > > The result I'm expecting for the above to be > > > > > >notification_time| finished_time | actual > > > +--

Re: [GENERAL] work hour calculations

2007-09-07 Thread Filip Rembiałkowski
2007/9/5, Raj A <[EMAIL PROTECTED]>: > correction: > > > The result I'm expecting for the above to be > > > >notification_time| finished_time | actual > > ++- > > 2007-07-06 15:50:00+10 | 2007-07-09 07:10:00+10 |

Re: [GENERAL] work hour calculations

2007-09-06 Thread Raj A
correction: > The result I'm expecting for the above to be > >notification_time| finished_time | actual > ++- > 2007-07-06 15:50:00+10 | 2007-07-09 07:10:00+10 | 01:20:00 > 2007-07-07 12:30:00+10 | 2007-07-09 07

Re: [GENERAL] work hour calculations

2007-09-04 Thread novice
correction: > The result I'm expecting for the above to be > >notification_time| finished_time | actual > ++- 2007-07-06 15:50:00+10 | 2007-07-09 07:10:00+10 | 01:20:00 > 2007-07-07 12:30:00+10 | 2007-07-09 07

[GENERAL] work hour calculations

2007-09-04 Thread novice
Hello All, SELECT notification_time, finished_time, sum(finished_time - notification_time) as actual FROM log GROUP BY notification_time, finished_time; gives me: notification_time| finished_time | actual ++- 20