you can use the mysql date function and format it as you're pulling it out
of MySql

select date(column_name, %m/%d/%Y) from table;

this will return it formatted like 11/18/2002  or there are other options.

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

this seems to be whar you're looking for...
hth
jeff


                                                                                       
                             
                    "Aaron Wolski"                                                     
                             
                    <aaronjw@marte       To:     "'Edward Peloke'" 
<[EMAIL PROTECTED]>, "'Php-Db'"                
                    kbiz.com>             <[EMAIL PROTECTED]>                       
                             
                                         cc:                                           
                             
                    11/18/2002           Subject:     RE: [PHP-DB] date()              
                             
                    02:26 PM                                                           
                             
                                                                                       
                             
                                                                                       
                             




Hmm.. I would get it into a unix_timestamp (unless someone can suggest a
reasoning for now doing so).

Select unix_timestamp(storedDate) as date FROM SomeTable where blah
blah"

Should work like that?

Aaron

-----Original Message-----
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: November 18, 2002 2:50 PM
To: 'Php-Db'
Subject: RE: [PHP-DB] date()

it is just a datetime field and the clients use a javascript calander to
pick the date, here is the exact date as it appears in the db.

2002-11-08 00:00:00

Eddie

-----Original Message-----
From: Aaron Wolski [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 2:05 PM
To: 'Edward Peloke'; 'Php-Db'
Subject: RE: [PHP-DB] date()


Ok..

I guess it depends on how your date is stored. I always use
unix_timestamps.

If you are too.. then the format I supplied should work as indicated.

Aaron

-----Original Message-----
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: November 18, 2002 2:19 PM
To: 'Php-Db'
Subject: RE: [PHP-DB] date()

When I use this, I get 12/31/69 as my date.

-----Original Message-----
From: Aaron Wolski [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 13, 2002 4:04 PM
To: 'Edward Peloke'; 'Php-Db'
Subject: RE: [PHP-DB] date()


$date = date("m:d:y", $myrow[datefield]);

Will produce: 11:13:02

http://www.php.net/manual/en/function.date.php


Aaron


-----Original Message-----
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: November 13, 2002 4:27 PM
To: Php-Db
Subject: [PHP-DB] date()

I have a date field in my mysql db, when I output the data to the
screen, I
don't want to see the minutes, just the mmddyy.  I can format a date but
can't seem to get it to work passing in the value from
$myrow["datefield"]....any ideas?  I don't want to have to worry about
just
pulling what I want in the select clause, I just want to format it when
I
diplay it.

Thanks,
Eddie


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




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


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




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


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




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





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

Reply via email to