# [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)
> >funct
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
quired before format
specifier characters. In earlier versions of MySQL, % was optional.
TIME_FORMAT(time,format)
This is used like the DATE_FORMAT() function above, but the format string
may contain only those format specifiers that handle hours, minutes, and
seconds. Other specifiers produce a NULL
timestamp 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
/manual/en/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 wi
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 28-
# [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
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
