ConvertToVTSTimeStamp
(ODBC Manager Library)Description: | Provides a format conversion of a time value from that used by the indicated database into a VTScada time stamp format |
Returns: | The time and date value, converted to a VTScada timestamp |
Usage: | Script only. |
Related to: | AddConnection | BuildDelete | BuildInsert | BuildSelect | BuildUpdate | ConvertToDbDate | ConvertToDbTime | ConvertToDbTimeStamp | ConvertToVTSTime | ConvertToVTSTimeStamp | CopyRecords | DBDropList | DBGridList | ErrMessage | ExecuteQuery | ExecuteQueryCached | FlushCache | FormatBatchQuery | GetConnList | ResultFormat | StatsWin | TableSynch | Transaction | TransactionCached |
Format: | \ODBCManager.ConvertToVTSTime( dbType, ValueIn[, FormatStr]) |
Parameters: |
dbType | ||||||
Required numeric value, indicating the type of this DB connection. At present, only MS SQL and Oracle are supported.
| ||||||
ValueIn | ||||||
Required. Time and date value as used by the indicated database. | ||||||
FormatStr | ||||||
Optional. Provides a format to use. Please refer to the BuffRead function for a description of the formatting options |
Comments: | This module is a member of the ODBCManager Library, and must therefore be prefaced by \ODBCManager, as shown in "Format" above. |