Previous Topic: XORBITS Function--Perform a Bitwise XOR Operation

Next Topic: YEAR4 Function--Return the Year Component of a Date (4 digits)

YEAR Function--Return the Year Component of a Numeric Date

The YEAR function returns a number that indicates the year component of a date in seconds since January 1, 1970.

Syntax

The YEAR function has the following format:

YEAR(date_time)

Parameters

The YEAR function accepts the following parameter:

date_time (number)

The date represented in seconds.

Return Value

The YEAR function returns a number between 70 and 138.

More information:

YEAR4 Function--Return the Year Component of a Date (4 digits)


Copyright © 2010 CA. All rights reserved. Email CA about this topic