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 | ExecuteQueryCachedFlushCache | 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.
DBTypeMeaning
0MS SQL
2Oracle
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.