Print      Open PDF Version of Online Help


Previous Topic

Next Topic

JulianMonth

The JulianMonth function in Expression Builder returns an integer that is equal to:

JulianYear * 12 + current_month

where JulianYear is the year that is returned by the JulianYear function, current_month is an integer from 1-12, and January is 1.

Syntax

JulianMonth(date)

Result Type

Integer

Arguments

The following table describes the arguments for the function.

Argument

Description

date

A field name that returns a date data type.

To return the value for today's date, use the following syntax:

JulianMonth(Today())

Related Topics

See the following topics for related Expression Builder information:


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.