sqlGetDate
Returns the date resulting from an SQL query.
sqlGetDate
(query
[, value1,
...
])
Parameters
query
The SQL query.
value1, ...
Variables of the SQL query.
Return value
The date type value that matches the query.
Remarks
Variables replace the parameters in the command. The variable
type must coincide with the parameter declared in the
command. These variables are available in a 'select' or
'update' type declaration. We have the following types:
- $(sz) string
- $(m) memo
- $(l) long
- $(s) short
- $(b) byte
- $(d) double
- $(f) float
- $(ts) timestamp
- $(dt) date
- $(tm) time
- $(dur) timespan in milliseconds (ms)
- $(id) Generates an identifier
- $(id:NmsTrackingLogId) Generates an identifier using a specific sequence
- $(curdate) Current date and time
var date = sqlGetDate('select tsBirth from nmsRecipient where sEmail =$(sz) order by tsCreated DESC LIMIT 1', email)
Features
Available in:
- Content management
- Delivery properties
- Typology rule
- JSSP
- SOAP Method
- WebApp
- Workflow