How will i get the difference between the two Date/time fields using sql?
BadgeNo, DateIn, TimeIn, DateOut, TimeOut
example (Inside the Database)
01 Mark oNe
02 Edwin Two
03 Sofia Three
badgeNo DateIn TimeIn DateOut TimeOut
01 11/21/2003 08:00:00 am 11/21/2003 09:00:00 am
02 11/21/2003 08:00:00 am 11/21/2003 10:00:00 am
01 11/21/2003 08:00:00 am 11/21/2003 11:00:00 am
03 11/21/2003 08:00:00 am 11/21/2003 09:00:00 am
WHEN displayed in my Grid
badgeNo FullName Total_Time
01 Mark oNe 4
02 Edwin Two 2
03 Sofia Three 1
formula must be (DateOut+timeOut) - (DateIn + TimeIn)
( 11/21/2003+09:00:00 am ) - (11/21/2003 + 08:00:00 am)
Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.
This article explains how to create forms/units independent of other forms/units object names in a delphi project.
Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech.
First you need to install the SAPI type library, th…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online.
The email signature template has been downloaded from: