Parsing a timestamp

[Anon]

Hi,

I am trying to parse a timestamp in mysql 3.21. How would I go about the result of my quiry when it is in the 20000809121212 format? I would like to display something like 08/09/2000, 12:12:12.

Thanks for your help in advance!

PG

[Anon]

take a look at the MySQL function DATE_FORMAT()

you can stuff like
SELECT DATE_FROMAT(date_feild,'%D %M %Y') as mydate from mytable

save a lot of arseing around in you PHP

Bealers

[Anon]

If you need to format a timestamp (and do so outside of the query) you need to use a regular expression:

mysql_connect("$DBHost","$DBUser","$DBPass") or die ("The database server is temporarily down for maintenance...");
$result=mysql("$DBName","SELECT entry_time FROM your_table");
while ($Nrow = mysql_fetch_row($result)) {
$Ntim=$Nrow[0];
$pieces=explode(":",$Ntim);
if ( ereg( "([0-9]{4})([0-9]{1,2})([0-9]{1,2})([0-9]{1,2})([0-9]{1,2})([0-9]{1,2})", $Ntim, $regs ) )
if ($Ntim != "") {
echo "$regs[2]/$regs[3]/$regs[1], $regs[4]:$regs[5]:$regs[6]";
}
}