(ODBC Manager Library)| Description: | Provides a conversion of a time value into the format used by the indicated database. |
| Returns: | The time value, converted to the specified database format |
Usage:  | Script only. |
| Related to: | AddConnection | BuildDelete | BuildInsert | BuildSelect | BuildUpdate | ConvertToDbDate | ConvertToDbTimeStamp | ConvertToVTSDate | ConvertToVTSTime | ConvertToVTSTimeStamp | CopyRecords | DBDropList | DBGridList | ErrMessage | ExecuteQuery | ExecuteQueryCached | FlushCache | FormatBatchQuery | GetConnList | ResultFormat | StatsWin | TableSynch | Transaction | TransactionCached |
| Format: | \ODBCManager.ConvertToDbTime( dbType, ValueIn[, NoDelimiters]) |
| Parameters: |
| dbType | ||||||||||||
Required numeric value, indicating the type of this DB connection.
| ||||||||||||
| ValueIn | ||||||||||||
| Required. Numeric time value expressed in seconds since midnight | ||||||||||||
| NoDelimiters | ||||||||||||
| Optional. 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. |
Example:
...
{ Convert time & date seperately }
DbDateStr = \ODBCManager.ConvertToDbDate(DbType, Int(GivenTimeStamp / \#SecPerDay), 1 {No delimiters});
DbTimeStr = \ODBCManager.ConvertToDbTime(DbType, GivenTimeStamp % \#SecPerDay, 1 {No delimiters });