ereg 搞格式

好耐無blog呢個.閒話休提!

MySQL可以將date轉為數字,方法係將佢+0,????

即係:
select dob from person where name="Fatkin";
就會出返1978/07/25;
如果想將佢變成數字,可以:
select dob+0 from person where name="Fatkin";
19780725
由於轉左做數字,換言之就係可以做calculation:
$startday=19700101;
$enddate=19791231;
select name from person where dob between $startday and $enddate;
但若我想將display返出0黎果陣可以有格式d,可以點做?

ereg ("([0-9]{4})([0-9]{2})([0-9]{2})",$startday, $regs);
unset ($regs[0]);
printf(implode("/", $regs));

舉左一隅,其餘三隅自己搞掂!