DataMigrator/Reporting Server > Simplified Date and Date-Time Functions > DT_CURRENT_DATE: Returning the Current Date

DT_CURRENT_DATE: Returning the Current Date

How to:

The DT_CURRENT_DATE function returns the current date-time provided by the running operating environment in date-time format. The time portion of the date-time is set to zero.

Syntax: How to Return the Current Date 

DT_CURRENT_DATE()

Example: Returning the Current Date

DT_CURRENT_DATE returns the current date. 

DT_CURRENT_DATE()

For September 8, 2016 (returning to a YYMD field), the result is 2016/09/08.

WebFOCUS

Feedback