I want to have all my dates from a mysql query to be in a UNIXTIME format.
How do I do this?
my current mysql query is as follows :
$result = mysql_query("SELECT * FROM datatable WHERE Bond = 'Fixed' AND Date > '1998-01-06' AND Date < '1998-07-17'");
I don't know where to add the following line :
Select UNIXTIME(Date) as Date FROM series113to182");
am I suppose to join this with the first query??
I want to keep the results from the first query but its just that I want the date in the UNIXTIME format.
How do I do this?
my current mysql query is as follows :
$result = mysql_query("SELECT * FROM datatable WHERE Bond = 'Fixed' AND Date > '1998-01-06' AND Date < '1998-07-17'");
I don't know where to add the following line :
Select UNIXTIME(Date) as Date FROM series113to182");
am I suppose to join this with the first query??
I want to keep the results from the first query but its just that I want the date in the UNIXTIME format.