note 52234 deleted from ref.com by cmb

Note Submitter: angelo [at] mandato <dot> com ---- ADO + PHP5 + SQL DATE FIELDS Using a COM("ADODB.Connection") object in PHP4 and PHP5 to return date fields in databases will have different results. In PHP4, the date is returned as a string as represented in the database. In my case, '2005-04-11 11:35:44'. In PHP5, the date is returned as a VARIANT type, when printed or implicitly casted would result as '4/11/2005 11:35:44 AM'. For this example, the solution is to use the variant conversion function variant_date_to_timestamp() to convert the value to a Unix timestamp. Please refer to this as an example. Other date types may be converted using one of the other variant_<convert> functions.