Format - method of object PmDateObject
Description:
Creates a text string containing date and time (according to the sFormat formatting rule).
Syntax:
Format(sFormat As String) As String
Parameters:
| sFormat | (String) Formatting rule for the date and time conversion into the string. Example: "%d.%m.%Y_%H:%M:%S.%T", where: d=day (01-31), m=month (01-12), Y=year (e.g. 2017), H=hour (00-23), M=minute (00-59), S=second (00-59), T=millisecond (000-999) - it is possible %nT, where n is count of figures 1, 2 or 3 Any of the chars %d, %m, %Y, %M, ... can be omitted and so to omit the corresponding time item in the presentation. |
|---|
Note:
Examples of commonly used formats:
%Y.%m.%d %H:%M:%S.%3T - The internal way of the date and time storing in the PROMOTIC system is in the form of 2017.10.11 15:23:28.082. This way ensures that the strings are sorted in compliance with the date and time sorting.
'%Y-%m-%d %H:%M:%S.%3T' - Creates the time in the format suitable for the
MSSQL database: '
2017-10-23 15:23:28.082'.
TIMESTAMP'%Y-%m-%d %H:%M:%S.%3T' - Creates the time in the format suitable for the
Oracle database:
TIMESTAMP'2017-10-23 15:23:28.082'.
'%Y-%m-%d %H:%M:%S' - Creates the time in the format suitable for the
MySQL database: '
2017-10-23 15:23:28'.
The method can also be called in the graphic item events for
Web panels.
Pm.FormatDate is a similar method.
Example:
JavaScriptSelect and copy to clipboard
var tDate = Pm.CreatePmDateObject();
var sDate = tDate.Format("%d.%m.%Y_%H:%M:%S.%2T");
//sDate contains "24.07.2005_17:06:35.00"