Difference between revisions of "STRFTIME()"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 14: | Line 14: | ||
==Description== | ==Description== | ||
| − | <expC1> is a | + | <expC1> is a string which may include any of the format elements from the table below. |
The optional <expC2> is a date or datetime in string format. If <expC2> is not specified, the current system date and time are assumed. | The optional <expC2> is a date or datetime in string format. If <expC2> is not specified, the current system date and time are assumed. | ||
Revision as of 17:19, 27 November 2009
Purpose
Syntax
STRFTIME(<expC1> [, <expC2> ])
See Also
AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAY(), DAYS(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), ELAPTIME(), EMPTY(), EPOCH(), GOMONTH(), HOUR(), HOURS(), LTOS(), MDY(), MINUTE(), MINUTES(), MONTH(), MTOD(), MTOS(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, SET VAXTIME, STOD(), STR(), TIME(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), TYPE(), VAL(), VALIDTIME(), VTOD(), WEEK(), YEAR()
Description
<expC1> is a string which may include any of the format elements from the table below. The optional <expC2> is a date or datetime in string format. If <expC2> is not specified, the current system date and time are assumed.
| Format Element | Description |
|---|---|
| Day | |
| %A | |
| %A | |
| %d | |
| %e | |
| %j | |
| %u | |
| %w | |
| Week | |
| %U | |
| %V | |
| %W | |
| Month | |
| %b | |
| %B | |
| %h | |
| %m | |
| Year | |
| %C | |
| %g | |
| %G | |
| %y | |
| %Y | |
| Time | |
| %H | |
| %I | |
| %l | |
| %M | |
| %p | |
| %P | |
| %r | |
| %R | |
| %S | |
| %T | |
| %X | |
| %z | |
| %Z | |
| Time and Date Stamps | |
| %c | |
| %D | |
| %F | |
| %s | |
| %x | |
| Miscellaneous | |
| %n%D | |
| %t%D | |
| %%%D%%%n%n |
Example
Products
Recital, Recital Server
