Ever wanted to create an attribute of type timestamp to a unix timestamp?
SELECT UNIX_TIMESTAMP(mydate) FROM mytable;
