| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
SQL.SetParamAsDateTime
Sets parameter's value as DateTime data.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| SQL | 2.6 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "SQL.SetParamAsDateTime"; Command; Param; Value ) More
(old name: SQL.SetParamAsTimestamp)
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" |
| Value | The new value |
Result
Returns "OK" or error message.
Description
Sets parameter's value as DateTime data.Reports an error for invalid date. Version 8.0 and newer set parameter to NULL if you pass empty value.
See also
- SQL.ConvertDateTimeToSQL
- SQL.GetFieldAsDateTime
- SQL.GetParamAsDate
- SQL.GetParamAsDateTime
- SQL.GetParamAsTime
- SQL.NewCommand
- SQL.RowsAffected
- SQL.SetParamAsDate
- SQL.SetParamAsTime
- SQL.SetParamDataType
Release notes
- Version 8.0
- Changed SQL.SetParamAsDateTime and SQL.SetParamAsDate to set param to NULL if you pass empty value.
Blog Entries
This function is free to use.
Created 18th August 2014, last changed 31st January 2019
