I have a Datetime field - "2023-06-08 15:10:48’ , When I am Trying to convert it tostring It gives following output “2023-06-08 15:10:48.000”.
Its giving some extra zeros. Can someone tell , How to fix this issues.
Hi @Vivek54 - You can always use split function and remove the .000 . Please see the documentation for the same - Split - Amazon QuickSight
Regards - Sanjeeb
1 Like
Thanks Sanjeeb. That’s exactly what I did, but want to know why this behavior , adding Extra zeros.
1 Like
Thanks @Vivek54 . Quick Sight internally considered this as timestamp ( I am suspecting ) and adding extra zeros . Anyway glad to know that the issue is fixed.
Have a wonderful week ahead.
Regards - Sanjeeb
2 Likes