Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   Index

DATE.CLOCKLIST

Converts an epoch format long integer representing milliseconds since Jan 1, 1970, 0:00 GMT, into a single-row list with columns representing various date/time fields and formats.

Syntax

<DATE.CLOCKLIST 
      LISTVARNAME="listvarname" 
      [CLOCK="longinteger"]
      [TIMEZONE="timezone"]/> 

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.

Parameters

LISTVARNAME (required)

Input parameter (see as output, below). Name of a list to create with broken out date formats.

CLOCK (optional)

Input parameter. Long integer value of milliseconds since Jan 1, 1970 0:00 GMT. The default is now, or the current clock value.

TIMEZONE (optional)

Input parameter. Time zone name. The default is system default.

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="-03:00" TIMEZONE="+06:00".

LISTVARNAME

Output parameter. A list is created with the following columns:

• fulldate - for example, "Saturday, April 6, 2001"
• fulltime - for example, "1:05:00 o'clock AM EST"
• longdate - for example, "April 6, 2001"
• longtime - for example, "1:05:00 AM EST"
• year - four-digit year
• month - integer month, January=1, December=11
• dayofmonth - integer day of month, 1-31
• dayofweek - integer day of week 1-7, Sunday=1
• hour - integer hour 0-11
• minute - integer minute 0-59
• second - integer second 0-59
• millisecond - integer millisecond 0-999
• ampm - integer, am=0, pm=1
• clock - integer, milliseconds since Jan 1, 1970 0:00 GMT

		Home >	Contents >	Index >
	Oracle XML Tag Reference Copyright (c) 2013, 2019, Oracle and/or its affiliates. All rights reserved.