Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
i need current date dimension object,DB2
- Thread starter Eswar75
- Start date
BrianTyler
IS-IT--Management
If it is actually a date you require, use
CURRENT DATE
as the dimension SQL in Designer. You do not need to wrap anything else around it, even though it looks odd to have a space in a 'function'.
For example, SELECT CURRENT DATE FROM TAB1 is valid SQL.
CURRENT DATE
as the dimension SQL in Designer. You do not need to wrap anything else around it, even though it looks odd to have a space in a 'function'.
For example, SELECT CURRENT DATE FROM TAB1 is valid SQL.
- Status
Similar threads
- Locked
- Question
- Locked
- Question