Returns current date/time according to user specified format.
d -> 6/15/2008
D -> Sunday, June 15, 2008
f -> Sunday, June 15, 2008 9:15 PM
F -> Sunday, June 15, 2008 9:15:07 PM
g -> 6/15/2008 21:15
G -> 6/15/2008 21:15
m -> 15-Jun
o -> 2008-06-15T21:15:07.0000000
R -> Sun, 15 Jun 2008 21:15:07 GMT
s -> 2008-06-15T21:15:07
t -> 9:15 PM
T -> 9:15:07 PM
u -> 2008-06-15 21:15:07Z
U -> Monday, June 16, 2008 4:15:07 AM
y -> June, 2008
->
h:mm:ss.ff t -> 15:07.0
d MMM yyyy -> 15-Jun-08
HH:mm:ss.f -> 15:07.0
dd MMM HH:mm:ss -> 6/15/2018 21:15
\Mon\t\h: M -> Month: 6
HH:mm:ss.ffffzzz -> 21:15:07.0000-07:00
timestamp 'd'
timestamp 'HH:mm:ss'
timestamp FormatString
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| FormatString | Text | Constant | Numeric data field. | No |
Type: Text