To do a stored procedure, and to let the customer input input in first, and then the start time in the morning to start time in the morning, after input afternoon start time to end time in the afternoon, I just don't know how to write these to parameters in the diagram and how to judge, and the system can't we in the condition of box directly select the date/time need to manually enter the time, that I how to judge a date/time this time

CodePudding user response:

We use the SQL server database

CodePudding user response:

The date of the above is a month

CodePudding user response:

Function isdate determine whether to date or time;
Datediff function to calculate interval

 - determine whether as time type 
The select ISDATE (' 2020-01-17 23:00:00) - is 
The select isdate (' 12:00:00) - is 
Is the select isdate (' 2020-01-17 ') -- 
The select isdate (' 3 ') - not 
Select DATEDIFF (HOUR, 'but', '"'), time (days) 
Select DATEDIFF (MINUTE, 'but', '"'), time (hours)