Previous Topic: MOD Function--Return Division Remainder

Next Topic: NOTBITS Function--Perform a Bitwise NOT

MONTH Function--Return the Month Component of a Date

The MONTH function returns the number representing the month component for a specified date_time expressed in seconds since January1, 1970.

Syntax

The MONTH function has the following format:

MONTH(date_time)

Parameters

The MONTH function accepts the following parameter:

date_time (number)

The date represented in the number of seconds.

Return Value

The MONTH function returns a number between 1 and 12. If the date_number is invalid, MONTH returns -1.

More information:

DAY Function--Return Day of Month

DOW Function--Return Day of Week

DOY Function--Return Day of Year

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

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


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