(ODBC Manager Library)| Description: | Provides a format conversion of a time value, from that used by the indicated database, to that used by VTScada |
| Returns: | The time value, converted to the standard VTScada format |
Usage:  | Script only. |
| Related to: | AddConnection | BuildDelete | BuildInsert | BuildSelect | BuildUpdate | ConvertToDbDate | ConvertToDbTime | ConvertToDbTimeStamp | ConvertToVTSDate | ConvertToVTSTimeStamp | CopyRecords | DBDropList | DBGridList | ErrMessage | ExecuteQuery | ExecuteQueryCached | FlushCache | FormatBatchQuery | GetConnList | ResultFormat | StatsWin | TableSynch | Transaction | TransactionCached |
| Format: | \ODBCManager.ConvertToVTSTime( dbType, ValueIn) |
| Parameters: |
| dbType | ||||||
Required numeric value, indicating the type of this DB connection. At present, only MS SQL and Oracle are supported.
| ||||||
| ValueIn | ||||||
| Required. Time value as used by the indicated database. |
| Comments: | This module is a member of the ODBCManager Library, and must therefore be prefaced by \ODBCManager, as shown in "Format" above. |
Example:
[
VTTime;
RightNow;
]
Init[
RightNow = "14:25:01"; If 1 Main;
[
VTTime = \ODBCManager.ConvertToVTSTime(0, RightNow);
]
]This example will return VTTime as 51901.
