Hi Chandra,
That expression is generating an integer: 20190524 if you want it displayed without the thousand separators you can either try to format it or change the expression to:
# sq ( timestampMask ( $current_timestamp, 'yyyymmdd' ) )#
which will cause the generation of '20190524' .
//Henk
------------------------------
HENK CAZEMIER
------------------------------
Original Message:
Sent: Fri May 24, 2019 12:41 PM
From: Chandra Medarametla
Subject: Current_date
Tried , which is showing the above .
Thanks
------------------------------
Chandra Medarametla
Original Message:
Sent: Fri May 24, 2019 12:08 PM
From: HENK CAZEMIER
Subject: Current_date
please try:
# timestampMask ( $current_timestamp, 'yyyymmdd' )#
it will be executed during query planning and result in a literal date in the generated query.
//Henk
------------------------------
HENK CAZEMIER
Original Message:
Sent: Fri May 24, 2019 10:17 AM
From: Chandra Medarametla
Subject: Current_date
in 11.1.1 cant able convert to current_date to 'YYYYMMDD' back using sql server
tried with different function non of helping . any suggestions.
Thanks
------------------------------
Chandra Medarametla
------------------------------
#CognosAnalyticswithWatson