Differences

This shows you the differences between two versions of the page.

--- syntax:functions:format [2015/02/01 14:27] – created dmitry
+++ syntax:functions:format [2019/11/16 14:55] – dmitry
@@ Line 1: / Line 1: @@
-===== Format(date_as_number, format) =====
+===== format(date_as_number, format) =====
-Converts //date_as_number// into a text string according to //format//.
+Converts //date_as_number// into a text string according to a //format// string.
-^  Example  ^  Result  ^
+^  Example  ^  Result  ^  Notes  ^
-|  format(41640,'yyyyMMdd')  |  '20140101'  |
+|  format(41640,'yyyyMMdd')  |20140101  | 41640 corresponds to January 1st, 2014  |
-|  format(41640,'yy-MM-dd')  |  '14-01-01'  |
+|  format(41640,'yy-MM-dd')  |14-01-01  | 41640 corresponds to January 1st, 2014  |
 === Format string components ===
-Case-sensitive.
+A format string defines a formatting template for dates. Its components can be put together in any combination. If a character doesn't belong to a format component then it's inserted verbatim.
+Note that the colon (":") is not a valid symbol for file names and therefore mustn't be used in file names generated using a format string.
+**Attention** :!: The format components are case sensitive. For instance, "MM" (uppercase) and "mm" (lowercase) are frequently confused by new EasyMorph users but they denote different data/time components (see table below).
 ^  Character  ^  Description  ^
-|  d  |The day of the month, from 1 through 31.  |
+|  y  |The year, from 0 to 99.  |
-|  dd  |The day of the month, from 01 through 31.  |
+|  yy  |The year, from 00 to 99.  |
-|  ddd  |The abbreviated name of the day of the week.  |
+|  yyyy  |The year as a four-digit number.  |
 |  M  |The month, from 1 through 12.  |
 |  MM  |The month, from 01 through 12.  |
 |  MMM  |The abbreviated name of the month.  |
 |  MMMM  |The full name of the month.  |
-|  y  |The year, from 0 to 99.  |
+|  d  |The day of the month, from 1 through 31.  |
-|  yy  |The year, from 00 to 99.  |
+|  dd  |The day of the month, from 01 through 31.  |
-|  yyyy  |The year as a four-digit number.  |
+|  ddd  |The abbreviated name of the day of the week.  |
+|  h  |The hour, using a 12-hour clock from 1 to 12.  |
+|  hh  |The hour, using a 12-hour clock from 01 to 12.  |
+|  H  |The hour, using a 24-hour clock from 1 to 24.  |
+|  HH  |The hour, using a 24-hour clock from 01 to 24.  |
+|  m  |The minute, from 0 through 59.  |
+|  mm  |The minute, from 00 through 59.  |
+|  s  |The second, from 0 through 59.  |
+|  ss  |The second, from 00 through 59.  |
 === See also ===