Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
SQL.GetParamAsTime
Returns param's value as time value; converts if needed.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
SQL | 2.6 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "SQL.GetParamAsTime"; Command; Param ) More
Parameters
Parameter | Description | Example |
---|---|---|
Command | The command reference number gained with SQL.NewCommand. | $Command |
Param | The parameter name or ID. Pass number for ID, a text with parameter name or the index with # prefix. e.g. "#0" for first parameter. | "1" |
Result
Returns the value or error message.
Description
Returns param's value as time value; converts if needed.see also:
https://www.sqlapi.com/ApiDoc/class_s_a_param.html
Examples
Query value of first parameter:
MBS( "SQL.GetParamAsTime"; $Command; "#0" )
See also
- SQL.ConvertDateTimeFromSQL
- SQL.GetParamAsDate
- SQL.GetParamsAsJSON
- SQL.GetParamValue
- SQL.NewCommand
- SQL.SetParamAsDate
- SQL.SetParamAsDateTime
- SQL.SetParamAsNumber
- SQL.SetParamAsText
- SQL.SetParamAsTime
This function is free to use.
Created 18th August 2014, last changed 10th January 2020