@Tanisha_Shetty - Thanks for the confirmation. Given that you are trying to extract only the date portion from a timestamp, did you try the TRUNC function as documented in the following link ? Let me know if that works for you!
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Query with Date Filter for Redshift Dataset | 3 | 2877 | November 24, 2021 | |
| Issue with now() function | 2 | 2048 | December 6, 2022 | |
| I need to create a unique code adding string and date , also need to convert date to timestamp | 2 | 768 | September 29, 2022 | |
| Quicksight dataset not showing "Date" type fileds form Salesforce | 4 | 612 | October 21, 2022 | |
| Quicksight can not parse Date from dataset | 6 | 3770 | February 24, 2023 |