Show TOC

Date UnitsLocate this document in the navigation structure

Use

Code

Date Unit

Milliseconds

D

Days

86,400,000 ms

W

Weeks / Calendar Week

Note

The functions DGET and DTGET return the calendar week (CW) for the date unit Weeks.

For example:
  • The result of DGET(@date1, "W") will be the calendar week (CW) of @date1. If @date1 is 15/04/2014, the result will be 16.
  • The expression DTGET(@CREATE_DATETIME,'W') also returns the calendar week. For example, 01.01.2014 would return 1.

604,800,000 ms

M

Months

2,592,000,000 ms

Q

Quarters

7,776,000,000 ms

Y

Years

31,536,000,000 ms

C

Centuries

3,153,600,000,000 ms