Jump to content

Mysql query statement Using FROM_UNIXTIME with an insert query


bobby317

Recommended Posts

This is my query:

$query = "INSERT INTO events (eventID, date, startTime, endTime, eventName, description) VALUES (0, 'FROM_UNIXTIME($date)', '$fStartTime', '$fEndTime', '$eventName', '$description')";

 

I am trying to use FROM_UNIXTIME() function to convert the dates back and forth but all examples use it when updating the table and I am inserting the info into the table. 

 

Thanks for all the help

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.