|Subject||Re: [firebird-support] How to do Time calculation|
>Say for example one employee's entry and exit time may be multiple in a dayOne date and one time?
>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.
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 employeeWith regards,
>had worked for a day (i.e. for each >day)
>1) EmpNo Varchar(15)
>2) dtDate Date
>3) tmTime Time
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum: