TO_CHAR() function on mapd


#1

Hi,

I need TO_CHAR() function on mapd. But I couldn’t find in mapd tutorial. Do you have alternative solution for TO_CHAR function? I want to use like this ==> “TO_CHAR(t1.time, ‘YYYY-MM-DD’) as myDate”
I just want to see time field column in “YYY-MM-DD” format.

Thanks,
Kayhan


#2

Hi @Kayhan. Is your goal to recast a timestamp to a string? To change the date format of a timestamp for display? Or something else?


#3

Hi,
Yes my goal is recast a timestamp to a string with a different format.
Thanks