Re: how to convert timestamp value to string in MySql

[Rick James]

In fact, almost anything string-like that you do will give you a string. Try this on your table:

 SELECT ts,
        date(ts),
        time(ts),
        left(ts, 7) AS yyyy_mm
 FROM tbl;

ts+0 will turn the timestamp into a funky number -- don't do arithmetic on that!

DATE_ADD(ts, INTERVAL 1 DAY) is the way to do date arithmetic.