| Tag Link | [Date_Format] | Category | Date |
|---|---|---|---|
| Type | Substitution | Source Available | No |
| Support | Preferred | Version | 3.0 |
| Change | Unchanged | Data Source | Any |
| Output Type | String | Security | None |
| Implementation | LCAPI | Sets | Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0, Lasso 5.0, Lasso 3.x |
[Date_Format] outputs a Lasso date string or Lasso date data type in any format.
The first parameter should be a Lasso date data type or a string in Lasso date format. The
%D U.S. date format (mm/dd/yyyy).
%Q MySQL date format (yyyy
%q MySQL timestamp format (yyyymmddhhmmss).
%r 12
%T 24
%Y 4
%y 2
%m Month number (1=January, 12=December).
%B Full English month name (e.g. "January").
%b Abbreviated English month name (e.g. "Jan").
%d Day of month (1-31).
%w Day of week (1=Sunday, 7=Saturday).
%W Week of year.
%A Full English weekday name (e.g. "Wednesday").
%a Abbreviated English weekday name (e.g. "Wed").
%H 24
%h 12
%M Minute (0-59).
%S Second (0-59).
%p AM/PM for 12
%G GMT time zone indicator.
%z Time zone offset in relation to GMT (e.g. -0800).
%Z Time zone name.
%% A percent sign.
By default, all output is zero padded to two characters. For example, 02/03/2002.
A hyphen - between the % and the letter code instructs Lasso not to pad the output. For example, 2/3/2002
An underscore _ between the % and the letter instructs Lasso to pad the output with spaces. For example, 2/ 3/2002.
[Date_Format: 'Base Date',
[Date_Format: (Date),
| Required Parameters | |
|---|---|
| Base Date | The date to be formatted in Lasso Date format. |
| -Format | A string specifying how the date should be formatted. |
| Optional Parameters | |
| Encoding Keyword | Specifies the encoding for the tag's return value. Tags are encoded using |
The
To format a date for MySQL:
Use the [Date_Format] tag with an appropriate
[Date_Format: (Date),
2001-03-04