Home > Contents > Index >
DATE.CONVERT
Converts a specific date to an epoch format integer.
Note
If you take the result of
DATE.CLOCKLIST
and use it as an input value to DATE.CONVERT , the epoch date returned is different from the originally converted date becauseDATE.CLOCKLIST
is 1-based for month and day values, while DATE.CONVERT is 0-based for month and day values.Syntax
<DATE.CONVERT VARNAME="varname" YEAR="year" MONTH="month" DAY="day" [HOUR="hour"] [AMPM="ampm"] [MINUTE="minute"] [TIMEZONE="timezone"]/>Parameters
VARNAME
(required)- Input and output parameter. As input, name of a variable to create with the integer date format on output.
YEAR
(required)- Input parameter. The year number.
MONTH
(required)- Input parameter. The month number (0-based; that is, 0=January, 11=December).
DAY
(required)- Input parameter. The day number (0-based; that is, Sunday=0; Saturday=6.)
HOUR
(optional)- Input parameter. The hour number (default is
0
).
AMPM
(optional)- Input parameter. The am/pm specifier (default is
am
).
MINUTE
(optional)- Input parameter. The minute number (default is
0
).
TIMEZONE
(optional)- Input parameter. A specified time zone.
Note
Only North American time zones are recognized. For time zones elsewhere in the world, use a plus or minus offset to GMT; for example,
TIMEZONE="-3:00" TIMEZONE="+6:00"
Home > Contents > Index > Oracle XML Tag Reference
Copyright (c) 2013, 2015, Oracle and/or its affiliates. All rights reserved.