I need to create a timestamp field for a table who's rows need to expire after a certain amount of time. If I use the following:
`timestamp` TIMESTAMP DEFAULT NOW(),
It shows the time in a human readable format, it would be a lot easier if I could have it in epoch time so I can calculate with seconds. Is there a way I can create a field that will display the current time when a row is created in epoch time by default? Thanks!