Mark Hensler — Tue, 03 Dec 2002 05:52:19 +0000

I'm assuming you're using mySQL. mySQL has special fields for time data: DATE, DATETIME, TIME, TIMESTAMP, and YEAR. For some reason (probably habit formed from programming in PERL), people like to use the time() function and store it in an INT(11).

If this is the case, you can pull it out like so:
SELECT FROM_UNIXTIME(time_field,'%m-%d-%Y') FROM table_name

If the format is MMDDYYYY, you can pull it out like so:
SELECT CONCAT(SUBSTRING(time_field,1,2),'-',SUBSTRING(time_field,3,2),'-',SUBSTRING(time_field,5,4)) FROM table_name

If the format is YYYYMMDD, or YYYYMMDDHHMMSS, you can pull it out like so:
SELECT DATE_FORMAT(time_field,'%m-%d-%Y') FROM table_name

In the future, I recommend using the appropriate datatype.

FinalMjolnir666 — Tue, 03 Dec 2002 02:37:41 +0000

I would use date, not time personally. And just put it in text, not int.

I'm not quite sure what you're asking though.

necrotic — Tue, 03 Dec 2002 02:36:53 +0000

It would require you to make a function. You can't just extract something that is inserted as 11112002 and read it as 11-11-2002.

Something like this:

<?php
$time = '11112002';
$month=substr(0,2,$time);
$day=substr(2,2,$time);
$year=substr(4,4,$time);

$date = $month.\"-\".$day.\"-\".$year;
echo $date;
?>

It would change 11112002 to 11-11-2002