SQL.SetParamAsTime
------------------

Sets parameter's value as Time data.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [SQL](component_SQL.md) | [2.6](newinversion26.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "SQL.SetParamAsTime"; Command; Param; Value ) 

**MBS**( **"SQL.SetParamAsTime";** /\* Sets parameter's value as Time data. \*/  
**$Command**; /\* The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). \*/   
**$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.e.g. "1" \*/   
**$Value**) /\* The new value \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). | $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" |
| Value | The new value |  |

### Result

Returns "OK" or error message.

### Description

Sets parameter's value as Time data.  
### See also

- [SQL.ConvertDateTimeToSQL](SQLConvertDateTimeToSQL.md)
- [SQL.GetParamAsText](SQLGetParamAsText.md)
- [SQL.GetParamAsTime](SQLGetParamAsTime.md)
- [SQL.NewCommand](SQLNewCommand.md)
- [SQL.SetParamAsDate](SQLSetParamAsDate.md)
- [SQL.SetParamAsDateTime](SQLSetParamAsDateTime.md)
- [SQL.SetParamAsFloat](SQLSetParamAsFloat.md)
- [SQL.SetParamAsText](SQLSetParamAsText.md)
- [SQL.SetParamOption](SQLSetParamOption.md)
- [SQL.SetParamValue](SQLSetParamValue.md)

### Release notes

- **Version 9.1**
    - Fixed bug with [SQL.SetParamAsTime](http://www.mbsplugins.eu/SQLSetParamAsTime.shtml) and SQLAPI handling TIME field type for SQLite.

### Blog Entries

- [MBS FileMaker Plugin, version 9.1pr1](https://www.mbsplugins.de/archive/2019-02-06/MBS_FileMaker_Plugin_version_9/monkeybreadsoftware_blog_filemaker)

This function is free to use.

Created 18th August 2014 , last changed 13th January 2015

  
[SQL.SetParamAsText](SQLSetParamAsText.md) - [SQL.SetParamDataType](SQLSetParamDataType.md)

[HTML Version](SQLSetParamAsTime.shtml)