Hi
Here is the expression you need to use:
cast( {the query item being cast},time)
Best regards,
------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------
Original Message:
Sent: Wed May 11, 2022 10:51 AM
From: Priyanka Joshi
Subject: date timestamp to date
Thank you.It worked.Now I need to separate date and time for report requirement.
------------------------------
Priyanka Joshi
Original Message:
Sent: Tue May 10, 2022 08:44 PM
From: IAN HENDERSON
Subject: date timestamp to date
You would probably want to try to see if your data base has a native function for doing the casting. If not, use the common function cast. The former would be preferable as it would probably be more likely to be pushed down to the data base for processing rather than being processed locally.
cast ( {the query item being cast} ,date )
------------------------------
IAN HENDERSON
Original Message:
Sent: Tue May 10, 2022 02:45 PM
From: Priyanka Joshi
Subject: date timestamp to date
How can I convert date Timestamp to date in cognos analytics.please explain.
------------------------------
Priyanka Joshi
------------------------------
#CognosAnalyticswithWatson