datetime to human form.

Anon

Greetings,

As I have learned previously, in order to convert the date from a mySQL database to a human form, one would use this:

$date_mod = date("m/d/Y",$row["date"]);
if($date_mod == "12/31/1969") $date_mod = "N/A";
echo "$date_mod";

This would grab the date field, and convert it to a m/d/y format, if the result should be NULL or straight 00's, then the resulting date of 12/31/69 would be replaced with a N/A.

My question is, I am now working with a datetime field that requires BOTH the date AND the time.

As per the database, the format gets entered as such:

00/00/00 - 00:00:00

I'd like to be able to convert the date AND the time to human form. (even military time would be fine, so long as with my date conversions I get the time as well.)

I have found via search either time conversions or date conversions...but never both...

Any assistance in this dilema would be immensely appreciated.

blackmamba

Easy! You can convert them IN the query, much more efficient, using the mysql server function date_format()
Your query will look like this:
SELECT date_format(date, "%m/%d/%Y") AS date_mod, date_format(date, "%H:%i:%s") AS time_mod FROM table (etc. etc. rest of query...)
Make sure in "date_format(date..." that date is the name of the datetime field.
Then in your script you'll have 2 rows in the format you want:
$row["date_mod"]
$row["time_mod"]
They appear like that because of the AS whatever part. AS just gives the date_format() shite a name that you can reference easily, or in the case of a query use as an alias.
Hope that helps.

Anon

hello

try this and it will work

$today = getdate();
$month = $today['month'];
$mday = $today['mday'];
$year = $today['year'];
$what= "$month $mday, $year";

cheers
kalyan

blackmamba

kalyan, he isn't formatting a current date, rather a datetime string from a database entry.

Anon

You rock! That converted to this format:

01/01/2001 08:30:00

Now all I need to do is figure out a way to convert dates to AM/PM instead of military time. Any easy way to do this as well?

I plan to search for this, so if I find it before someone posts, I'll let you know.

Thanks a million!

blackmamba

Try changing this

SELECT date_format(date, "%m/%d/%Y") AS date_mod, date_format(date, "%H:%i:%s") AS time_mod FROM table

to this

SELECT date_format(date, "%m/%d/%Y") AS date_mod, date_format(date, "%r") AS time_mod FROM table

I've used %r instead of %H:%i:%s to format the time, it gives it back in 12 hour like so: hh:mm:ss AM/PM