Re: [PHP] TIMESTAMP -> Y-m-d

2003-06-07 Thread Don Read 

On 05-Jun-2003 nabil wrote:
> Please help me how to print a timestamp string retrived from the
> database,
> and print it as -MM-DD
> 

MySQL ?

http://www.mysql.com/doc/en/Date_and_time_functions.html

-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] TIMESTAMP -> Y-m-d

2003-06-05 Thread Marek Kilimajer 
mysql manual -> DATE_FORMAT() function. Simply do
SELECT DATE_FORMAT('format string', timestamp_column) ...
nabil wrote:
Please help me how to print a timestamp string retrived from the database,
and print it as -MM-DD
Nabil





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] TIMESTAMP -> Y-m-d

2003-06-05 Thread Justin French 
on 05/06/03 6:24 PM, Nabil Attar ([EMAIL PROTECTED]) wrote:

> mysql time stamp

well, there are a few different formats that can be returned, so rather than
me guessing which type, how about you tell us exactly what format you have
(by providing an example), and exactly what format you want to echo to the
screen.

or look at the user notes on http://au.php.net/strtotime or
http://au.php.net/mktime -- i'm sure there's examples.


justin


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] TIMESTAMP -> Y-m-d

2003-06-05 Thread Justin French 
A unix timestamp, or mysql timestamp?

for unix, see http://au.php.net/date

justin




on 05/06/03 5:38 PM, nabil ([EMAIL PROTECTED]) wrote:

> Please help me how to print a timestamp string retrived from the database,
> and print it as -MM-DD
> 
> Nabil
> 
> 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] TIMESTAMP -> Y-m-d

2003-06-05 Thread nabil 
Please help me how to print a timestamp string retrived from the database,
and print it as -MM-DD

Nabil



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php