Print      Open PDF Version of Online Help

Administering Oracle CRM On Demand > Expression Builder > Expression Builder Functions > JulianDay

Previous Topic

Next Topic

JulianDay

The JulianDay function in Expression Builder returns the number of days that have elapsed since noon Universal Time, January 1, 4713 BC.

Syntax

JulianDay(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:

JulianDay(Today())

Related Topics

See the following topics for related Expression Builder information:
Published 6/21/2021 Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices.