LucidDbAppLib DAY IN YEAR

From Eigenpedia

Jump to: navigation, search

Contents

Syntax 

   APPLIB.DAY_IN_YEAR ( [ date ] | [ timestamp ] | [ year, month, day ] )

Purpose

Returns the day number in a year of a given a date or timestamp.

Parameters

  • date: date used to calculate the day in year [date]
  • timestamp: timestamp used to calculate the day in year [timestamp]
  • year: year of the date used to calculate the day in year [integer]
  • month: month of the date used to calculate the day in year [integer]
  • day: day number within a month used to calculate the day in year [integer]

Output

  • [INTEGER] day number in year between 1 and 365 or null if any of the inputs are null

Example

Values( APPLIB.DAY_IN_YEAR(DATE'1900-12-13'), APPLIB.DAY_IN_YEAR(TIMESTAMP'2121-06-22 12:59:59'), APPLIB.DAY_IN_YEAR(2000, 1, 18) )

Returns:

DAY_IN_YEAR(DATE'1900-01-13')


DAY_IN_YEAR(TIMESTAMP'2121-06-22 12:59:59')

DAY_IN_YEAR(2000, 12, 13) 13 173 348

Source Code

http://p4web.eigenbase.org/open/dev/luciddb/src/com/lucidera/luciddb/applib/datetime/DayInYearUdf.java

Retrieved from "http://pub.eigenbase.org/wiki/LucidDbAppLib_DAY_IN_YEAR"
Personal tools