UFN_PHONE_VALIDTIMES
Validates the phone start and end times
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STARTTIME | UDT_HOURMINUTE | IN | |
| @ENDTIME | UDT_HOURMINUTE | IN |
Definition
Copy
create function dbo.UFN_PHONE_VALIDTIMES
(
@STARTTIME UDT_HOURMINUTE = '',
@ENDTIME UDT_HOURMINUTE = ''
)
returns bit with execute as caller
as
begin
if (@STARTTIME is not null) and (@STARTTIME <> '')
begin
if (@ENDTIME is null) or (@ENDTIME = '')
set @ENDTIME = @STARTTIME
if @STARTTIME <= @ENDTIME
return 1
else
return 0
end
return 1
end