| Format | Description | Example | Notes |
|---|---|---|---|
| %tc | date and time | 01jan1960 00:00:00.001 | |
| %tC | date and time | 01jan1960 00:00:00.001 | accounts for leap seconds |
| %td | date | 08sep1981 | |
| %tw | week | 1978w48 | |
| %tm | month | 1976m7 | |
| %tq | quarter | 1990q3 | |
| %th | half-year | 1980h2 | |
| %ty | year | 1983 |
| format | from strings | from numerical components |
|---|---|---|
| %tc | clock(string, mask) | mdyhms(M, D, Y, h, m, s) |
| dhms(td, h, m, s) | ||
| hms(h, m, s) | ||
| %tC | Clock(string, mask) | Cmdyhms(M, D, Y, h, m, s) |
| Cdhms(td, h, m, s) | ||
| Chms(h, m, s) | ||
| %td | date(string, mask) | mdy(M, D, Y) |
| %tw | weekly(string, mask) | yw(Y, W) |
| %tm | monthly(string, mask) | ym(Y, M) |
| %tq | quarterly(string, mask) | yq(Y, Q) |
| %th | halfyearly(string, mask) | yh(Y, H) |
| %ty | yearly(string, mask) |
To extract components from a date, use the following functions. For example, if you would like to create a new variable which holds only the year from a date expression, use yofd(dateexpr).
| from to: | %tc | %tC | %td | %tw | %tm | %tq | %th | %ty |
|---|---|---|---|---|---|---|---|---|
| %tc | -- | Cofc | dofc | |||||
| %tC | cofC | -- | dofc | |||||
| %td | cofd | Cofd | -- | wofd | mofd | qofd | hofd | yofd |
| %tw | dofw | -- | ||||||
| %tm | dofm | -- | ||||||
| %tq | dofq | -- | ||||||
| %th | dofh | -- | ||||||
| %ty | dofy | -- |