Uttam wrote:
u can use highly customizabe MySQL DATE_FORMAT() function for retrieving
date in desired format.
Thanks for the detailed information.
For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date)
function to return unix timestamp of the date and use the php date functions
# [EMAIL PROTECTED] / 2003-03-31 07:38:44 -0500:
Uttam wrote:
u can use highly customizabe MySQL DATE_FORMAT() function for retrieving
date in desired format.
Thanks for the detailed information.
For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date)
function to return
# [EMAIL PROTECTED] / 2003-03-28 21:47:28 -0500:
I'm experienced with SQL, but new to MySql and PHP, which I'm using
together to create a dynamic web site. Right now, I'm having minor
difficulties with date formatting. It seems that when I retrieve a date
from MySQL into PHP, it shows up
This is not a MySQL question.
http://www.php.net/manual/en/function.explode.php (probably)
visit: http://www.php.net/links.php for tutorials on PHP.
If you can control the layout of the database you could use another type of
column. See the MySQL manual for more information.
B.
At 21:47
/function.strtotime.php).
Mark
-Original Message-
From: Roman Neuhauser [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 9:28 AM
To: Bruce Feist
Cc: MySQL List
Subject: Re: MySql, PHP, and Dates
# [EMAIL PROTECTED] / 2003-03-28 21:47:28 -0500:
I'm experienced with SQL, but new to MySql
u can use highly customizabe MySQL DATE_FORMAT() function for retrieving
date in desired format. Relevant portion from manual is reprodcued below
inside quotes.
For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date)
function to return unix timestamp of the date and use the php