Re: timestamp problem !!

thanks Jason, you've been always helping me ... Please i still have some fog regading this.. can u expaling me more about the timestamp and unix timestamp... and regaring me issue i have a string with '20030714012548' what ever i got it from (because i m getting this from MSSQL some time and then read it from MySQL, and i need to desplay it in as 2003-07-14 only .. What' shall i do ? Nabil "Jason Wong" <php-general@gremlins.biz> wrote in message news:200307150406.22944.php-general@gremlins.biz... > On Wednesday 16 July 2003 02:00, Nabil wrote: > > > <?php > > $timy = '20030714012548'; // time stamp from MySQL > > echo strtotime = ($timy); > > $date = ("Y-m-d" , $timy); > > ?> > > > > and i have a wrong result.... how can i extract the YYYY-MM-DD from the > > string $timy.... > > MySQL TIMESTAMP != UNIX TIMESTAMP > > Look up the date/time functions in MySQL. > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.biz > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > ------------------------------------------ > Search the list archives before you post > http://marc.theaimsgroup.com/?l=php-general > ------------------------------------------ > /* > Why do they put Braille dots on the keypad of the drive-up ATM? > -- Why Why Why n29 > */ >