4D v12.1
New date and time formats (String command)
- 4D Addendum 12.1
-
- New date and time formats (String command)
- Rich text areas
- PHP
- Database settings
- Export using SQL
- Renaming 4D HTML tags
- 4D Server, 64-bit version
- Command to help convert subtables
- Support of SSL in 4D Internet Commands
New date and time formats (String command)
4D v12.1 provides new automatic date/time formats to make it easier to generate time stamps. These formats are particuarly useful with XML and Web processing .
These new formats are available using the existing String command. In order to handle date/time combinations, this command now accepts an optional third parameter: combTime. This Time type parameter is used only when the expression parameter is a Date (see below).
The ISO Date date format (returns a date in ISO8601 format) can now combine a time with the result obtained when you pass a time in the third parameter:
$mydate:=String(Current date;ISO Date) // returns for example 2010-09-13T00:00:00
$mydate:=String(Current date;ISO Date;Current time) // now returns 2010-09-13T18:11:53The new ISO Date GMT date format is similar to the ISO Date format except that it expresses the date and time with respect to the time zone (the ISO Date format expresses the local date and time).
$mydate:=String(Current date;ISO Date GMT;Current time) // returns 2010-09-13T16:11:53ZNote that the "Z" character at the end indicates the GMT format.
If you only pass a date, the command returns the date at midnight (local time) expressed in GMT time which may cause the date to be moved forward or back depending on the local time zone:
$mydate:=String(Current date;ISO Date GMT) // in Paris, France this returns 2010-09-12T22:00:00ZYou can use the new Date RFC 1123 date format to format a date/time combination according to the standard defined by RFC 822 and 1123. You need this format for example to set the expiration date for cookies in an HTTP header.
$mydate:=String(Current date;Date RFC 1123;Current time) // returns for example Fri, 10 Sep 2010 13:07:20 GMTThe time expressed takes the time zone into account (GMT zone). If you only pass a date, the command returns the date at midnight (local time) expressed in GMT time which may cause the date to be moved forward or back depending on the local time zone:
$mydate:=mydate(Current date;Date RFC 1123) // e.g. in Paris, France, returns Thu, 09 Sep 2010 22:00:00 GMT
Product: 4D
Theme: New date and time formats (String command)
