Skip to content

Instantly share code, notes, and snippets.

@nomanson

nomanson/formatDateTime.php

Created August 4, 2012 20:46
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save nomanson/3259827 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save nomanson/3259827 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. nomanson created this gist Aug 4, 2012.
    55 changes: 55 additions & 0 deletions formatDateTime.php
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,55 @@
    function format_datetime($examine_query)
    {
    $split_query = explode("FROM", $examine_query);

    $result = mysql_query($examine_query);
    $numfields = mysql_num_fields($result);
    for ($i = 0; $i < $numfields; $i++)
    {
    $field_info = mysql_field_type($result, $i);
    $field_name = mysql_field_name($result, $i);


    if ($field_name == "date" or $field_name == "time")
    {
    if ($field_name == "date")
    {
    $split_query[0] = str_replace($field_name, "DATE_FORMAT($field_name, '%D %M %Y') as $field_name",
    $split_query[0]);

    }
    if ($field_name == "time")
    {
    $split_query[0] = str_replace($field_name, "DATE_FORMAT($field_name, '%H:%i') as $field_name",
    $split_query[0]);

    }

    }
    else
    {

    if ($field_info == timestamp or $field_info == datetime)
    {
    $split_query[0] = str_replace($field_name, "DATE_FORMAT($field_name, '%D %M %Y %H:%i') as $field_name",
    $split_query[0]);
    }
    if ($field_info == date)
    {
    $split_query[0] = str_replace($field_name, "DATE_FORMAT($field_name, '%D %M %Y') as $field_name",
    $split_query[0]);
    }
    if ($field_info == time)
    {
    $split_query[0] = str_replace($field_name, "DATE_FORMAT($field_name, '%H:%i') as $field_name",
    $split_query[0]);
    }
    }
    }


    $examine_query = $split_query[0] . " FROM " . $split_query[1];
    echo $examine_query;
    return $examine_query;

    }