Re: Is partitioning helpful in this case?

[Shantanu Oak]

>> Is it a good idea to add an additional datetime field to the table and create a trigger to convert the timestamp to a datetime value when the row is added?

No. Infact it is a very bad idea.
_____

You can use partitions even if you save a unix timestamp to the database instead of a datetime value. The only precaution needs to be taken is to write a correct select query that will take advantage of partitions.