MySQL - Combine two fields to create a unix timestamp?
- by Dan
Hi,
I'm trying to retrieve a UNIX timestamp from a query by combining a date and a time field in the table, however it keeps returning as zero.
SELECT *,
UNIX_TIMESTAMP(startdate starttime) AS start,
UNIX_TIMESTAMP(enddate endtime) AS end
FROM mytable;
Can anyone help me out?
Thanks.