[Eikinskjaldi]

Originally Posted by Marco van Herwaarden

Working with a Unix timestamp is much easier in software. It is easier to sort or do calculations.

Just have to agree to disagree on that one.

Within mysql, to turn a unixtime into a date time, use from_unixtime(val). To turn a datetime into a unixtime, use unix_timestamp(val). You can, for instance, do unix_timestamp(now())

And if you wanted to determine some date range from the timestamp, you can convert to datetime and then use the various mysql functions (which is why I think working with datetime is the preferred option) so for instance if you wanted all the posts from the last 14 days you could use

where to_days(now()) - to_days(from_unixtime(post.dateline)) <= 14.