NOW

The NOW function outputs the current date and time.

Input/Output

Number of Connections: 0
OutputData TypeDescription
Output1DateTime, StringThe current date and time.

Property

NameProperty TypeDescription
Formatchoice Specifies how to format the input DateTime data to a string.
Outputs DateTime value when Format is set to "(datetime)". Otherwise, outputs String.
You can specify the format directly except for pre-defined format. For details of format, please refer the following topic "Date and Time Patterns".
(datetime) - Example:2006-09-27T16:36:44.840 JST
yyyy/MM/dd HH:mm:ss - Example:2006/09/27 16:36:44
yyyy/MM/dd hh:mm:ss - Example:2006/09/27 04:36:44
yyyy/MM/dd - Example:2006/09/27
ggggeeee年M月d日H時m分s秒 - Example:平成18年9月27日16時36分44秒
ggggeeee年M月d日h時m分s秒 - Example:平成18年9月27日4時36分44秒
ggggeeee年M月d日 - Example:平成18年9月27日
geeee年M月d日H時m分s秒 - Example:H18年9月27日16時36分44秒
geeee年M月d日h時m分s秒 - Example:H18年9月27日4時36分44秒
geeee年M月d日 - Example:H18年9月27日
TruncateTimebooleanSpecifies whether sets 00:00:00 to time.
true [true] - Sets 00:00:00
false [false] - Don't set
TimeZonechoiceSpecifies the time zone when Format is specified
System Timezone [(default)]
The system's default time zone is used.
(GMT) [(GMT)]
Greenwich Mean Time is used.
LocalechoiceDefines the locale when Format is specified
System Locale [(default)] - The system's default locale is used.

Date and Time Patterns

It is described by combining the following letters.

SymbolMeaningMeaning
gEra nameHeisei
eYear corresponding to era name18
Gera designatorAD
yyear2003
Mmonth in yearJuly and 07
dday in month10
hhour in am/pm (1-12)11
Hhour in day (0-23)0
mminute in hour45
ssecond in minute54
Smillisecond955
Eday in weekTuesday
Dday in year145
Fday of week in month2 (2nd Wed in July)
wweek in year24
Wweek in month2
aam/pm markerPM
khour in day (1-24)24
Khour in am/pm (0-11)0
ztime zonePacific Standard Time
'escape for text
''single quote'

Example

PropertyOutput
Input1noneFormat(datetime)2003/05/01T12:00:00.013

PropertyOutput
Input1noneFormatyyyy/MM/dd2006/09/12