PlaySQL - how to format a column

[Yohan BOURGOIN]

Hi,

In my SELECT, with :       TO_CHAR(W.startdate,'YYYY-MM-DD') AS "Date"

i obtain values like :          <p>2015-03-16</p>

I suppose these are html tags ... i don't understand why they are printed and how i can suppress them ...

Thanks in advance for your help 

Antoine

PlaySQL 2.10.9 on standalone tomcat/confluence 5.8.8

[Yohan BOURGOIN · Accepted solution]

I don't know why, but a "CAST .. AS date" instead of the TO_CHAR is ok ...

Question closed, thanks for all

Antoine

[Yohan BOURGOIN]

Thanks for your prompt answer ! 

But i don't have "Text" proposed, only numeric, integer, money, joint ID ...

Capture d’écran 2015-08-18 à 15.48.24.png

(The W.startdate field is timestamp, and i use pg 9.1)

Thanks for your help

Antoine

[Adrien Ragot 2]

It's really strange that the type is "DOUBLE". Did you set it yourself? Can you contact me in private at support@play-sql.com and tell me what is your database vendor and your full query?

[Adrien Ragot 2]

Hi Antoine,

The "Markdown" type is selected by default in some situations. Click on the column header, then on the cog, and there are several types you can choose from. Select the Text icon ('T').

Best regards,

Adrien