Format - method of object PmDateObject

Description:

According to the sFormat formatting rule it creates a string containing date and time.

Syntax:

Format(sFormat As String) As String

Calling:

s = Pm.Format(sFormat)

Parameters:

sFormat	(String) Formatting rule for the date and time conversion into the string. Example: "%d.%m.%Y_%H:%M:%S.%T" d=day (1-31), m=month (1-12), Y=year (e.g. 2017), H=hour, M=minute, S=second, T=millisecond (0-999) - it is possible %nT, where n is count of figures 1, 2 or 3 Any of the formatting chars %d, %m, %Y, %M, ... can be omitted and so to omit the corresponding time item in the presentation.

sFormat

(String) Formatting rule for the date and time conversion into the string. Example: "%d.%m.%Y_%H:%M:%S.%T"

d=day (1-31),

m=month (1-12),

Y=year (e.g. 2017),

H=hour,

M=minute,

S=second,

T=millisecond (0-999) - it is possible %nT, where n is count of figures 1, 2 or 3

Any of the formatting 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 MS SQL server 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'.

#%d %m %Y %H:%M:%S# - Creates the time in the format suitable for the Microsoft Access, dBase, PARADOX, etc. databases when setting the direct access, see Direct access to table - DAO, #10 23 2017 15:23:28#.

The method can also be called in the graphic item events for Web panels.

Pm.FormatDate is a similar method.