Return MySQL timestamp on insert

Question

When I perform an insert statement to a MySQL database in PHP, is there a way to return the auto-generated timestamp or do I need a separate call to the database to retrieve the data?

Edit: I forgot that MySQL doesn't use epoch dates. I decided to just use an autoincrementing integer and a stored procedure.

Answer 1

You need to make a separate request to get that information. You can only get the last insert ID of auto incremented tables when doing an INSERT.