Difference between revisions of "MONTH()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
==Class==
 
Date and Time Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return month from a specified date or datetime
 
Function to return month from a specified date or datetime
Line 16: Line 12:
  
 
==Description==
 
==Description==
The MONTH() function returns the numeric month of the year from the given date expression <expD> or datatime expression <expT>.
+
The MONTH() function returns the numeric month of the year from the given date expression <expD> or datetime expression <expT>.
  
  
Line 29: Line 25:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 09:43, 27 August 2015

Purpose

Function to return month from a specified date or datetime


Syntax

MONTH(<expD> | <expT>)


See Also

CDOW(), CMONTH(), CTOD(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), EPOCH(), GOMONTH(), MDY(), MTOD(), QUARTER(), STOD(), VTOD(), WEEK(), YEAR(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK


Description

The MONTH() function returns the numeric month of the year from the given date expression <expD> or datetime expression <expT>.


Example

? month(date())
        10
? month(datetime())
        10


Products

Recital, Recital Server