Timestamp To String

Question & Answer
,
1

I want to convert timestamp to string, I am able to use the ToString function but I just want the date and not the hh:mm:ss.

ToString(sent_date)

Current Output: 2023-02-28 00:00:00
Required Output: 2023-02-08

2

will it always be in that format YYYY-MM-DD?

If so can you take the substring of the first 10?

substring(toString(sent_date),1,10)

2 Likes
3

As always easy and to the point solution… simple loved it.

Regards - San

1 Like
5

Thanks for sharing this feedback @Sanjeeb2022! Yes, @Max and his team at West Loop are awesome. Grateful for expert answers! @patilmeet7, if Max’s solution works for you, can you mark Max’s reply as “Solution” (check box under his reply)? This will help our community out a lot! Thx!