Last active
August 29, 2015 14:06
-
-
Save phenix-factory/6fb990dcae5598022462 to your computer and use it in GitHub Desktop.
Fonction qui va normaliser n'importe quel format de date au format sql DATETIME
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
/** | |
* Fonction qui va normaliser n'importe quel format de date au format sql DATETIME | |
* | |
* @param mixed $date | |
* @access public | |
* @return mixed | |
*/ | |
function filtre_normaliser_date_sql_dist($date) { | |
include_spip('inc/filtres'); | |
// Cas d'un timestamp | |
if (is_numeric($date)) { | |
return date('Y-m-d h:i:s', $date); | |
} | |
// enlever les valeurs considerees comme nulles (1 1 1970, etc...) | |
if ($date = vider_date($date)) { | |
// Récupérer la date via la fontion idoine. | |
list($annee, $mois, $jour, $heures, $minutes, $secondes) = recup_date($date); | |
// La fonction recup_date coupe le 0 de début d'un jour | |
// sql à besoin de ce 0 donc on remet | |
if ($jour < 10) | |
$jour = '0'.$jour; | |
// Dans le cas de heure/minute/seconde à 0 sql demande un double 00 | |
if ($heures == 0) | |
$heures = '00'; | |
if ($minutes == 0) | |
$minutes = '00'; | |
if ($secondes == 0) | |
$secondes = '00'; | |
// Renvoyer le format sql DATETIME | |
return $annee.'-'.$mois.'-'.$jour.' '.$heures.':'.$minutes.':'.$secondes; | |
} | |
else | |
return false; | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment