Subject Re: [firebird-support] How to do Time calculation
Author Martijn Tonies
>Say for example one employee's entry and exit time may be multiple in a day
>why I need only one date and time column based on this i will do rest
>because i don't know how many times employee might have gone out side and
>again came in for the same day. >so, as per this i think one date and one
>time column is enough.

One date and one time?

Can you give sample data as to how you would like to calculate this then?

>Now as per following columns how i will calculate the total time employee
>had worked for a day (i.e. for each >day)
>1) EmpNo Varchar(15)
>2) dtDate Date
>3) tmTime Time

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: