ConvertToDbDate

(ODBC Manager Library)

Description Provides a conversion of a date value into the format used by the indicated database.
Returns The date value, converted to the specified database format
Usage Script only.
Related to: AddConnection | BuildDelete | BuildInsert | BuildSelect | BuildUpdate | ConvertToDbTime | ConvertToDbTimeStamp | ConvertToVTSDate | ConvertToVTSTime | ConvertToVTSTimeStamp | CopyRecords | DBDropList | DBGridList | ErrMessage | ExecuteQuery | ExecuteQueryCachedFlushCache | FormatBatchQuery | GetConnList | ResultFormat | StatsWin | TableSynch | Transaction | TransactionCached
Format \ODBCManager\ConvertToDbDate(  dbType,  ValueIn[,  NoDelimiters])
Parameters  
dbType
Required numeric value, indicating the type of this DB connection.
DBTypeMeaning
0MS SQL
1MS Access
2Oracle
3MySQL
4SyBase
ValueIn
Required. Numeric time value expressed in days since January 1, 1970
NoDelimiters
Optional. Any Boolean expression. If this parameter evaluates to true (non-zero), then text delimiters will be suppressed in the output value.
Defaults to true
Comments This module is a member of the ODBCManager Library, and must therefore be prefaced by \ODBCManager\, as shown in "Format" above.