Date Format Help

[paulspoon]

I've got a text field with the following value "20060710" and want to convert it to look like this "2005/07/10".

All help appreciated

[brown2005]

post some code on how you got the date please

[CheesierAngel]

I suppose the date is not generated but inputted by the costumers. You could use:

[code]
<?php
  $notGood = "20060710";
  $match = array();
  if(preg_match('/^([0-9]){4}([0-9]){2}([0-9]){2})/', $notGood, $match)) {
    $good = $match[0] . "/" . $match[1] . "/" . $match[2];
  }

  echo notGood . " - " . $good;
?>
[/code]

Or you could use following aswell:
[code]
<?php
  $notGood = "20060710";
  $match = array();
  if(preg_match('/^([0-9]){4}([0-9]){2}([0-9]){2})/', $notGood, $match)) {
    $good = date('YYYY/m/d', mktime('', '', '', $match[1], $match[2], $match[0]));
  }
  echo $good;
?>
[/code]

[paulspoon]

Doesn't work ?

Parse error: syntax error, unexpected '[' in /Data/www/dev.cha

please help

[CheesierAngel]

You can change it to

[code]
<?php
    if(preg_match('/^(\d){4}(\d){2}(\d){2}/', $notGood, $match)) {
        ....
    }
?>
[/code]

[paulspoon]

Still nothing , next error

Parse error: syntax error, unexpected T_STRING in /Data/www/dev.cha

Sorry for the inconvinience

[CheesierAngel]

Just tested it and is working:

[code]
<?php
  $notGood = "20060710";
  $match = array();
  $good = "";
  if(preg_match('/^([0-9]){4}([0-9]){2}([0-9]){2}/', $notGood, $match)) {
    $good = date('Y/m/d', mktime('', '', '', $match[1], $match[2], $match[0]));
  }
  echo $good;
?>
[/code]

Also working:
[code]
<?php
  $notGood = "20060710";
  $match = array();
  if(preg_match('/^([0-9]){4}([0-9]){2}([0-9]){2}/', $notGood, $match)) {
    $good = $match[0] . "/" . $match[1] . "/" . $match[2];
  }

  echo $notGood . " - " . $good;
?>
[/code]

Sorry, was forgotten some $ signs and had a ) sign too much in.

[BillyBoB]

$datefromdb = $sominhere['time_data'];
$year = substr($datefromdb,0,4);
$mon  = substr($datefromdb,4,2);
$day  = substr($datefromdb,6,2);
$hour = substr($datefromdb,8,2);
$min  = substr($datefromdb,10,2);
$sec  = substr($datefromdb,12,2);
$orgdate = date("l F dS, Y h:i A",mktime($hour,$min,$sec,$mon,$day,$year));
?>
Date: <? echo $orgdate; ?>