Converting date to String

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 . QuickSight 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