MySQL DATETIME & PHP

[Wynder]

Writing a work order system and I'm attempting to track various statistics like how long it takes a workorder to go from submitted to completed.

I'm currently trying to find this out:

Can PHP create the format of the MySQL DATETIME data type? If so, how? If not, could someone reccomend a better alternative?

So, how would one go about getting the different between two DATETIME variables leaving me with the time inbetween?

[magic-chef]

The date functioncan be used in conjunction with the unix timestamp.

$currentdt=date('U');//Gives Unix Timestamp

$currentdt=date("Y-m-d g:i:s", $currentdt);//converts Unix timestamp to MySQL Datetime format

There are other format options available for this. See the date function in PHP docs.

[magic-chef]

You could also:

$currentdate=date("Y-m-d g:i:s")

without the timestamp portion this returns the current info.