Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   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 because DATE.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, Oracle and/or its affiliates. All rights reserved.