Date Function
Returns a date in its internal system format.
Syntax
Date ( )Remarks
IBM® InfoSphere® DataStage® stores dates as the number of days before or after day 0, using 31 December 1967 as day 0. For example:
- This date...
- Is stored as...
- December 10, 1967
- -21
- November 15, 1967
- -46
- December 31, 1967
- 0
- February 15, 1968
- 46
- January 1, 1985
- 6575
Use the internal date whenever you need to perform output conversions.
Example
This example shows how to turn the current date in internal form into a string representing the next day:
Tomorrow = Oconv(Date() + 1, "D4/YMD") ;* "1997/5/24"