Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

Time.Format

Formats a date with C time formatting functions.

Component Version macOS Windows Linux Server iOS SDK
Time 6.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Time.Format"; TimeStamp; FormatString { ; Locale } )   More

Parameters

Parameter Description Example Flags
TimeStamp The FileMaker time stamp. Get(CurrentTimeStamp)
FormatString The format string.
Locale The locale to use.
Be aware that identifiers are not the same on Mac, Windows and Linux.
"FR_fr" Optional

Result

Returns text or error.

Description

Formats a date with C time formatting functions.
locale is the name of the locale to use. You can pass empty string to use default/current locale.
Format is a format string like for strftime command in C.

The format specification is a string and may contain special character sequences called conversion specifications, each of which is introduced by a '%' character and terminated by some other character known as a conversion specifier character. All other character sequences are ordinary character sequences.

The characters of ordinary character sequences (including the null byte) are copied verbatim from format to s. However, the characters of conversion specifications are replaced as follows:

%aThe abbreviated weekday name according to the current locale.
%AThe full weekday name according to the current locale.
%bThe abbreviated month name according to the current locale.
%BThe full month name according to the current locale.
%cThe preferred date and time representation for the current locale.
%CThe century number (year/100) as a 2-digit integer. (SU)
%dThe day of the month as a decimal number (range 01 to 31).
%DEquivalent to %m/%d/%y. (Yecch-for Americans only. Americans should note that in other countries %d/%m/%y is rather common. This means that in international context this format is ambiguous and should not be used.) (SU)
%eLike %d, the day of the month as a decimal number, but a leading zero is replaced by a space. (SU)
%EModifier: use alternative format, see below. (SU) (Not on Windows)
%FEquivalent to %Y-%m-%d (the ISO 8601 date format).
%GThe ISO 8601 week-based year (see NOTES) with century as a decimal number. The 4-digit year corresponding to the ISO week number (see %V). This has the same format and value as %Y, except that if the ISO week number belongs to the previous or next year, that year is used instead. (TZ)
%gLike %G, but without century, that is, with a 2-digit year (00-99). (TZ)
%hEquivalent to %b. (SU)
%HThe hour as a decimal number using a 24-hour clock (range 00 to 23).
%IThe hour as a decimal number using a 12-hour clock (range 01 to 12).
%jThe day of the year as a decimal number (range 001 to 366).
%kThe hour (24-hour clock) as a decimal number (range 0 to 23); single digits are preceded by a blank. (See also %H.) (TZ) (Not on Windows)
%lThe hour (12-hour clock) as a decimal number (range 1 to 12); single digits are preceded by a blank. (See also %I.) (TZ) (Not on Windows)
%mThe month as a decimal number (range 01 to 12).
%MThe minute as a decimal number (range 00 to 59).
%nA newline character. (SU)
%OModifier: use alternative format, see below. (SU) (Not on Windows)
%pEither "AM" or "PM" according to the given time value, or the corresponding strings for the current locale. Noon is treated as "PM" and midnight as "AM".
%PLike %p but in lowercase: "am" or "pm" or a corresponding string for the current locale. (GNU) (Not on Windows)
%rThe time in a.m. or p.m. notation. In the POSIX locale this is equivalent to %I:%M:%S %p. (SU)
%RThe time in 24-hour notation (%H:%M). (SU) For a version including the seconds, see %T below.
%sThe number of seconds since the Epoch, 1970-01-01 00:00:00 +0000 (UTC). (TZ) (Not on Windows)
%SThe second as a decimal number (range 00 to 60). (The range is up to 60 to allow for occasional leap seconds.)
%tA tab character. (SU)
%TThe time in 24-hour notation (%H:%M:%S). (SU)
%uThe day of the week as a decimal, range 1 to 7, Monday being 1. See also %w. (SU)
%UThe week number of the current year as a decimal number, range 00 to 53, starting with the first Sunday as the first day of week 01. See also %V and %W.
%VThe ISO 8601 week number (see NOTES) of the current year as a decimal number, range 01 to 53, where week 1 is the first week that has at least 4 days in the new year. See also %U and %W. (SU)
%wThe day of the week as a decimal, range 0 to 6, Sunday being 0. See also %u.
%WThe week number of the current year as a decimal number, range 00 to 53, starting with the first Monday as the first day of week 01.
%xThe preferred date representation for the current locale without the time.
%XThe preferred time representation for the current locale without the date.
%yThe year as a decimal number without a century (range 00 to 99).
%YThe year as a decimal number including the century.
%zThe +hhmm or -hhmm numeric timezone (that is, the hour and minute offset from UTC). (SU)
%ZThe timezone or name or abbreviation.
%+The date and time in date(1) format. (TZ) (Not supported in glibc2.) (Not on Windows)
%%A literal '%' character.

Some conversion specifications can be modified by preceding the conversion specifier character by the E or O modifier to indicate that an alternative format should be used. If the alternative format or specification does not exist for the current locale, the behavior will be as if the unmodified conversion specification were used. (SU) The Single UNIX Specification mentions %Ec, %EC, %Ex, %EX, %Ey, %EY, %Od, %Oe, %OH, %OI, %Om, %OM, %OS, %Ou, %OU, %OV, %Ow, %OW, %Oy, where the effect of the O modifier is to use alternative numeric symbols (say, roman numerals), and that of the E modifier is to use a locale-dependent alternative representation.

Examples

Formats a date:

MBS( "Time.Format"; Get ( CurrentTimeStamp ); "%d %B %Y" )

Example result: 11 December 2016

Formats a date in french:

MBS( "Time.Format"; Get ( CurrentTimeStamp ); "%d %B %Y"; "FR_fr" )

Example result: 11 décembre 2016

Format a timestamp for MySQL:

MBS( "Time.Format"; Get ( CurrentTimeStamp ); "%Y-%m-%d %H:%M:%S" )

Example result: 2016-12-11 11:35:26

Time for HTTP Request:

MBS( "Time.Format"; Get ( CurrentTimeStamp ); "%a, %d %b %Y %H:%M:%S %Z")

Example result: Sun, 11 Dec 2016 11:36:18 CET

Query week number:

MBS( "Time.Format"; Get(HostTimeStamp); "%W")

Calculate time with time zone with double colon:

Let([
t = MBS( "Time.Format"; Get ( CurrentTimeStamp ); "%a, %d %b %Y %H:%M:%S %z");
l = Length ( t );
w = Position ( t ; ":" ; 1 ; 3 );
r = if(w > 0; t; Left ( t ; l-2 ) & ":" & Middle ( t ; l-2 ; 2 ))
]; t & ¶ & r)

Example result: Fri, 12 Apr 2024 21:03:00 +02:20

See also

Release notes

  • Version 10.2
    • Fixed a problem on Windows with Time.Format and time zones.
  • Version 9.3
  • Version 8.1
    • Added check for Time.Format on Windows to better report invalid parameter.

Example Databases

Blog Entries

This function is free to use.

Created 17th August 2016, last changed 12nd April 2024


TextView.Undo - Time.Parse