DataMigrator/Reporting Server > SQL Date and Time Functions > DAYS: Obtaining the Number of Days Since January 1, 0001

DAYS: Obtaining the Number of Days Since January 1, 0001

How to:

The DAYS function returns 1 more than the number of days from January 1, 0001 to the provided date value.

Syntax: How to Obtain the Number of Days Since January 1, 1900 

DAYS(arg)

where:

arg

Date or timestamp

Is the input argument.

This function returns an integer value.

Example: Obtaining the Number of Days Since January 1, 1900

DAYS returns one more than the number of days since January 1, 1900. 

DAYS('2000-01-01')

returns 730120.

WebFOCUS

Feedback