Promotic
WikipediaLinkedInYoutubeTwitterFacebook

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. 2016),
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 2016.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: '2016-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'2016-10-23 15:23:28.082'.
'%Y-%m-%d %H:%M:%S' - Creates the time in the format suitable for the MySql database: '2016-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 2016 15:23:28#.
 
The method can also be called in the graphic item events for Web Panels.
 
Pm.FormatDate is a similar method.
Example:
var sDate = tDate.Format("%d.%m.%Y_%H:%M:%S.%2T");
  //sDate contains "24.07.2005_17:06:35.00"
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice