Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

SQL.GetParamAsDateTime

Returns param's value as timestamp value; converts if needed.

Component Version macOS Windows Linux Server iOS SDK
SQL 2.6 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "SQL.GetParamAsDateTime"; Command; Param )   More

(old name: SQL.GetParamAsTimestamp)

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 timestamp value; converts if needed.

see also:
https://www.sqlapi.com/ApiDoc/class_s_a_param.html

Examples

Query value of first parameter:

MBS( "SQL.GetParamAsDateTime"; $Command; "#0" )

See also

This function is free to use.

Created 18th August 2014, last changed 10th January 2020


SQL.GetParamAsDate - SQL.GetParamAsFloat