I'm saving in mysql table dates with time() func as INT
is there a way to directly convert such dates from INT to DAT like yy-mm-dd directly with Mysql query?
or i always have to make it with php, no other chance?
you can use the mysql function FROM_UNIXTIME to do this.
Why not store the dates in date form, e.g. using a DATE or DATETIME column?
Brad has a point -- unix timestamps often have time zone offsets applied to them somewhat unpredictably. It's been my experience that Datetime values in MySQL are more reliable and easily understood (try converting a unix time to a real date in your head). It sort of depends on what you're doing with them however.
