note 76849 modified in function.mktime by danbrown

As per derrick miller's contribution for MySQL date stamps (which equally applies to pgSQL)... I find this processes a little faster than exploding the string: (All done in one statement) <?php function unix_date($input_date) { // take date string such as "1985-07-25" and return the Unix timestamp return mktime(0, 0, 0, substr($input_date, 5, 2), substr($input_date, 8, 2), substr($input_date, 0,4)); } ?> --was-- As per derrick miller's contribution for MySQL date stamps (which equally applies to pgSQL)... I find this processes a little faster than exploding the string: (All done in one statement) function unix_date($input_date) { // take date string such as "1985-07-25" and return the Unix timestamp return mktime(0, 0, 0, substr($input_date, 5, 2), substr($input_date, 8, 2), substr($input_date, 0,4)); } http://php.net/manual/en/function.mktime.php