Time Intrinsic Functions - AsValue Method
Return the variable as a value if SQLNull
Member of Time Intrinsic Functions (PRIM_LIBI.ITimeIntrinsics)
Parameters
Name | Type | Data Type | Description |
|---|---|---|---|
Result | *Result (Optional) | Time | Resulting value |
Default | *Input (Optional) | Time | Value to use when the variable is SQLNull |
Details
AsValue allows you to better handle *SQLNull. Rather than having to test for a potential SQLnull, AsValue allows a variable to return a specified value.
Example
Rather than having to test as below
If ((#Variable = "00:00:00") *or (#Variable.IsSqlNull)
...
AsValue allows the following
If (#Variable.AsValue(00:00:00))
...