Use datsbetween said "training time later than the end of the training start time"

CodePudding user response:

Much to the conditions and instructions, did not understand the original poster?

CodePudding user response:

Select the value of your time between end of the training time and training start time

CodePudding user response:

Should use datediff SQL

CodePudding user response:

Example

 
This example to determine in the pubs database header release date and the number of days during the current day, 

USE pubs 
GO 
The SELECT DATEDIFF (day, for its pubdate, getdate ()) AS no_of_days 
The FROM titles 
GO 

CodePudding user response:

DateBetween said the absolute value of events is poor, so your request can not reach,

Determine whether in some time later, can be directly do subtraction,
If date1 date2 - & lt; 0 then showmessage (' date1 later than date2);