ULTIMATE DATABASE

Format a date using the php date() function

• d - The day of the month (from 01 to 31) - 24
• D - A textual representation of a day (three letters) - Mon
• j - The day of the month without leading zeros (1 to 31) - 24
• l (lowercase 'L') - A full textual representation of a day - Monday
• N - The ISO-8601 numeric representation of a day (1 for Monday, 7 for Sunday) - 1
• S - The English ordinal suffix for the day of the month (2 characters st, nd, rd or th. Works well with j) - th
• w - A numeric representation of the day (0 for Sunday, 6 for Saturday) - 1
• z - The day of the year (from 0 through 365) - 235
• W - The ISO-8601 week number of year (weeks starting on Monday) - 35
• F - A full textual representation of a month (January through December) - August
• m - A numeric representation of a month (from 01 to 12) - 08
• M - A short textual representation of a month (three letters) - Aug
• n - A numeric representation of a month, without leading zeros (1 to 12) - 8
• t - The number of days in the given month - 31
• L - Whether it's a leap year (1 if it is a leap year, 0 otherwise) - 0
• o - The ISO-8601 year number - 2026
• Y - A four digit representation of a year - 2026
• y - A two digit representation of a year - 26
• a - Lowercase am or pm - am
• A - Uppercase AM or PM - AM
• B - Swatch Internet time (000 to 999) - 046
• g - 12-hour format of an hour (1 to 12) - 12
• G - 24-hour format of an hour (0 to 23) - 0
• h - 12-hour format of an hour (01 to 12) - 12
• H - 24-hour format of an hour (00 to 23) - 00
• i - Minutes with leading zeros (00 to 59) - 07
• s - Seconds, with leading zeros (00 to 59) - 27
• u - Microseconds - 000000
• e - The timezone identifier (Examples: UTC, GMT, Atlantic/Azores) - UTC
• I (capital i) - Whether the date is in daylights savings time (1 if Daylight Savings Time, 0 otherwise) - 0
• O - Difference to Greenwich time (GMT) in hours (Example: +0100) - +0000
• P - Difference to Greenwich time (GMT) in hours:minutes - +00:00
• T - Timezone abbreviations (Examples: EST, MDT) - UTC
• Z - Timezone offset in seconds. The offset for timezones west of UTC is negative (-43200 to 50400) - 0
• c - The ISO-8601 date (e.g. 2013-05-05T16:34:42+00:00) - 2026-08-24T00:07:27+00:00
• r - The RFC 2822 formatted date (e.g. Fri, 12 Apr 2013 12:01:05 +0200) - Mon, 24 Aug 2026 00:07:27 +0000
• U - The seconds since the Unix Epoch (January 1 1970 00:00:00 GMT) - 1787530047

See php.net/manual/en/function.date.php for more details.

If you pass in an empty date value then this function will use today's date.
If you pass in an X then it will return nothing.
This can be useful when formating a date from an XML field by setting the default value of the OBJ_DATA command to X.