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
and return a date in any format you please.
Peter.
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Sent: Saturday, 29 March 2003 1:17 PM
To: MySQL List
Subject: MySql, PHP, and Dates
I'm experienced with SQL, but new to MySql and PHP, which I'm using
together to create
that handle hours, minutes, and
seconds. Other specifiers produce a NULL value or 0.
---quote
regards,
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 29, 2003 08:17
To: MySQL List
Subject: MySql, PHP, and Dates
I'm
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 as a string instead of a date data
type, with format