Difference between revisions of "STRFTIME()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 10: | Line 10: | ||
==See Also== | ==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== | ==Description== | ||
| − | + | <expC1> is a formatting string composed of the format elements in 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. | ||
| Line 20: | Line 21: | ||
!Format Element||Description | !Format Element||Description | ||
|- | |- | ||
| − | |Day|| | + | |'''Day'''|| |
|- | |- | ||
|%A|| | |%A|| | ||
| Line 36: | Line 37: | ||
|%w|| | |%w|| | ||
|- | |- | ||
| − | |Week|| | + | |'''Week'''|| |
|- | |- | ||
|%U|| | |%U|| | ||
| Line 44: | Line 45: | ||
|%W|| | |%W|| | ||
|- | |- | ||
| − | |Month|| | + | |'''Month'''|| |
|- | |- | ||
|%b|| | |%b|| | ||
| Line 54: | Line 55: | ||
|%m|| | |%m|| | ||
|- | |- | ||
| − | |Year|| | + | |'''Year'''|| |
|- | |- | ||
|%C|| | |%C|| | ||
| Line 66: | Line 67: | ||
|%Y|| | |%Y|| | ||
|- | |- | ||
| − | |Time|| | + | |'''Time'''|| |
|- | |- | ||
|%H|| | |%H|| | ||
| Line 94: | Line 95: | ||
|%Z|| | |%Z|| | ||
|- | |- | ||
| − | |Time and Date Stamps|| | + | |'''Time and Date Stamps'''|| |
|- | |- | ||
|%c|| | |%c|| | ||
| Line 128: | Line 129: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| − | [[Category: | + | [[Category:Date and Time Data]] |
| − | [[Category: | + | [[Category:Date and Time Data Functions]] |
Revision as of 17:18, 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 formatting string composed of the format elements in 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
