good!
I always store any time in unix timestamp.
This way it be be transformed into any local date format
when you want to use it and display.
Unix timestamp is in seconds. Easy to adjust for timezone. 1 hour = 3600 sec.
We only take: timeoffset * 3600, and add/subtract to get local timezone.
Your old dates was stored like: 20060703155721
which is equal to: date( "YmdHis", time() )
To convert your old dates into whatever format, you can use this script.
I have tested it and it works!
<?php
$string = '20060703155721';
// pull out parts of string
$hour = substr($string, 8, 2 );
$min = substr($string, 10, 2 );
$sec = substr($string, 12, 2 );
$month= substr($string, 4, 2 );
$day = substr($string, 6, 2 );
$year = substr($string, 0, 4 );
// make timestamp from : // h m s m d y
$unixstamp = mktime($hour,$min,$sec,$month,$day,$year);
// format your custom date of timestamp
$mydate = date( "F j, Y, g:i a", $unixstamp);
echo $mydate;
