Re: [PHP] format date field
On Wed, May 23, 2007 11:45 am, Mike Ryan wrote: I am reading in a date field from a mysql database the field on the screen shows up as 2007-05-01 on the screen I would like the field to show 05-01-2007 currently I am issueing the following command print $row['open']; how can I format this field??? while I am at it how can I accept the date field as 05-01-2007; http://dev.mysql.com/ Search date_format will answer the first one. The seocnd is probably a configurable setting at mysql startup, but I'd be leery of altering that... -- Some people have a gift link here. Know what I want? I want you to buy a CD from some indie artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] format date field
I am reading in a date field from a mysql database the field on the screen shows up as 2007-05-01 on the screen I would like the field to show 05-01-2007 currently I am issueing the following command print $row['open']; how can I format this field??? while I am at it how can I accept the date field as 05-01-2007; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] format date field
On 5/23/07, Mike Ryan [EMAIL PROTECTED] wrote: I am reading in a date field from a mysql database the field on the screen shows up as 2007-05-01 on the screen I would like the field to show 05-01-2007 currently I am issueing the following command print $row['open']; how can I format this field??? while I am at it how can I accept the date field as 05-01-2007; Look at MySQL's DATE_FORMAT() function. -- Greg Donald http://destiney.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] format date field
Leave the date as is, its a MySQL thing. To format it on your page, use the date function: $formattedDate = date(m-d-Y,strtotime($row[open])); http://us2.php.net/manual/en/function.date.php -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada Community College www.wncc.edu 775-445-3326 On May 23, 2007, at 9:45 AM, Mike Ryan wrote: I am reading in a date field from a mysql database the field on the screen shows up as 2007-05-01 on the screen I would like the field to show 05-01-2007 currently I am issueing the following command print $row['open']; how can I format this field??? while I am at it how can I accept the date field as 05-01-2007; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Format Date
Hi, When i print a date, the format of this date is: 8 nov 2001 0:00 (print ($array[date])) but i need print this: 08/11/2001 how i print this ? ass.: Augusto Flavio __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Format Date
When i print a date, the format of this date is: 8 nov 2001 0:00 (print ($array[date])) but i need print this: 08/11/2001 how i print this ? Hmmm... well I want to say RTFM, but in light of the recent posts... :) Take a look at the date() function. www.php.net/date You can format your date with that. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Format Date
you can do date('d/m/Y',strtotime($array['date'])), or better would be
to change
the format at the source
dark rotter wrote:
Hi,
When i print a date, the format of this date is: 8 nov
2001 0:00
(print ($array[date]))
but i need print this: 08/11/2001
how i print this ?
ass.: Augusto Flavio
__
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] format date
I just started with php and am trying to display a query result for a date
field as mm/dd/ instead of mysql's -mm-dd. I looked through some
books and found the use of DATE_FORMAT to covert the dates. Is there any
other way to format the date?
Thanks
My script looks like this:
$month_1 = ($date_month_1);
$day_1 = ($date_day_1);
$year_1 = ($date_year_1);
$month_2 = ($date_month_2);
$day_2 = ($date_day_2);
$year_2 = ($date_year_2);
$query = SELECT * FROM tablename where date = '$year_1-month_1-$day_1-'
AND
date = '$year_2-$month_2-$day_2';
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
echo pNumber of records found: .$num_results./p;
for ($i=0; $i $num_results; $i++)
{
$row = mysql_fetch_array($result);
echo pstrong.($i+1).. ID: ;
echo ($row[id]);
echo /strongbrFirst name: ;
echo ($row[fname]);
echo brLast name: ;
echo ($row[lname]);
echo brDate: ;
echo ($row[date]);
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] format date
Hey Alex,
I use a short function like this because the date is really just a string
you can pick it apart and re-arrange it.
function Format_Date($Date){
return $Date =
((substr($Date,6,2)).-.(substr($Date,0,2)).-.(substr($Date,3,2)));
}
Steve.
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 1:36 PM
To: [EMAIL PROTECTED]
Subject: [PHP] format date
I just started with php and am trying to display a query result for a date
field as mm/dd/ instead of mysql's -mm-dd. I looked through some
books and found the use of DATE_FORMAT to covert the dates. Is there any
other way to format the date?
Thanks
My script looks like this:
$month_1 = ($date_month_1);
$day_1 = ($date_day_1);
$year_1 = ($date_year_1);
$month_2 = ($date_month_2);
$day_2 = ($date_day_2);
$year_2 = ($date_year_2);
$query = SELECT * FROM tablename where date = '$year_1-month_1-$day_1-'
AND
date = '$year_2-$month_2-$day_2';
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
echo pNumber of records found: .$num_results./p;
for ($i=0; $i $num_results; $i++)
{
$row = mysql_fetch_array($result);
echo pstrong.($i+1).. ID: ;
echo ($row[id]);
echo /strongbrFirst name: ;
echo ($row[fname]);
echo brLast name: ;
echo ($row[lname]);
echo brDate: ;
echo ($row[date]);
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] format date
Change your query, mySQL provides some powerful formatting functions for
doing exactly what you want:
SELECT id,
fname,
lname,
DATE_FORMAT( date, '%m/%d/%Y' )
FROM tablename where date = '$year_1-month_1-$day_1-'
AND
date = '$year_2-$month_2-$day_2';
Cheers,
Rob.
---
Steve Bradwell wrote:
Hey Alex,
I use a short function like this because the date is really just a string
you can pick it apart and re-arrange it.
function Format_Date($Date){
return $Date =
((substr($Date,6,2)).-.(substr($Date,0,2)).-.(substr($Date,3,2)));
}
Steve.
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 1:36 PM
To: [EMAIL PROTECTED]
Subject: [PHP] format date
I just started with php and am trying to display a query result for a date
field as mm/dd/ instead of mysql's -mm-dd. I looked through some
books and found the use of DATE_FORMAT to covert the dates. Is there any
other way to format the date?
Thanks
My script looks like this:
$month_1 = ($date_month_1);
$day_1 = ($date_day_1);
$year_1 = ($date_year_1);
$month_2 = ($date_month_2);
$day_2 = ($date_day_2);
$year_2 = ($date_year_2);
$query = SELECT * FROM tablename where date = '$year_1-month_1-$day_1-'
AND
date = '$year_2-$month_2-$day_2';
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
echo pNumber of records found: .$num_results./p;
for ($i=0; $i $num_results; $i++)
{
$row = mysql_fetch_array($result);
echo pstrong.($i+1).. ID: ;
echo ($row[id]);
echo /strongbrFirst name: ;
echo ($row[fname]);
echo brLast name: ;
echo ($row[lname]);
echo brDate: ;
echo ($row[date]);
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
.-.
| Robert Cummings |
:-`.
| Webdeployer - Chief PHP and Java Programmer |
:--:
| Mail : mailto:[EMAIL PROTECTED] |
| Phone : (613) 731-4046 x.109 |
:--:
| Website : http://www.webmotion.com |
| Fax : (613) 260-9545 |
`--'
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] format date
On Tuesday, April 16, 2002, at 01:35 PM, Alex wrote:
I just started with php and am trying to display a query result for a
date
field as mm/dd/ instead of mysql's -mm-dd. I looked through
some
books and found the use of DATE_FORMAT to covert the dates. Is there any
other way to format the date?
Thanks
My script looks like this:
$month_1 = ($date_month_1);
$day_1 = ($date_day_1);
$year_1 = ($date_year_1);
$month_2 = ($date_month_2);
$day_2 = ($date_day_2);
$year_2 = ($date_year_2);
$query = SELECT * FROM tablename where date =
'$year_1-month_1-$day_1-'
AND
date = '$year_2-$month_2-$day_2';
As a recent convert from my own custom date-formatting techniques (can
you believe I was storing my dates in VARCHAR(14) columns?) to the
standards of MySQL's DATE_FORMAT function, I can't really recommend this
approach. Why not just take your variables and format them into a
single string? It'll be much, much simpler once you get used to it
// your date data in variables:
$month_1 = ($date_month_1);
$day_1 = ($date_day_1);
$year_1 = ($date_year_1);
$month_2 = ($date_month_2);
$day_2 = ($date_day_2);
$year_2 = ($date_year_2);
// create a timestamp representing the date data
$timestamp_1 = mktime(0, 0, 0, $month_1, $day_1, $year_1);
$timestamp_2 = mktime(0, 0, 0, $month_2, $day_2, $year_2);
// format the timestamps into the format preferred by MySQL's
// DATE column type
$timestamp_1 = date('Ymd', $timestamp_1);
$timestamp_2 = date('Ymd', $timestamp_2);
// your new and improved, and much cleaner query
$query = SELECT *
FROM tablename
WHERE date = '$timestamp_1'
ANDdate = '$timestamp_2'
;
It may seem like more work, but it's much neater, and you have these
portable timestamps that can always be reformatted to whatever format
you like for display. (Also, be sure to use either DATE_FORMAT or
UNIX_TIMESTAMP in MySQL queries to pull the data out in a desired
format! Much better than running string functions on the date result
after the fact.)
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] format date
Thanks,
I am inserting into table
values('$product','$title,'$date')
the date field gets added by default, like time stamp,
when i view the contents added to database i see date field showing
ex:
display.php
$product, $title, $date
mango good fruit Jan 1 1900 12:00:00:000AM
.
I would like the date to show 23-10-01 instead of
Jan 1 1900 12:00:00:000AM that gets inserted as a default
any help
Caleb Carvalho
Application Engineer
LoadRunner/APM
-
Enterprise Testing and Performance Management Solutions
-
Mercury Interactive
410 Frimley Business Park
Frimley, Surrey. GU16 7ST
United Kingdom
Telephone : +44 (0)1276 808300
From: David Robley [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Caleb Carvalho [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [PHP] format date
Date: Tue, 23 Oct 2001 10:02:26 +0930
On Mon, 22 Oct 2001 22:38, Caleb Carvalho wrote:
Hi all,
i would like a simple way to get date field formatted from my little
sybase,
for some reason the output of it is showing the wrong date
example Jan 1 1900 12:00:00:000AM
thanks
Perhaps if you could show what you are doing and which is not working,
someone might be able to help you. As it is we have no idea of the format
of your data or the method you are using.
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
Politics is the entertainment branch of industry.
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] format date
I don't know if this will help but there's from_unixtime() function in mysql.
use values($some,$another,from_unixtime(.
time().),..
On Tuesday 23 October 2001 03:52 am, you wrote:
Thanks,
I am inserting into table
values('$product','$title,'$date')
the date field gets added by default, like time stamp,
when i view the contents added to database i see date field showing
ex:
display.php
$product, $title, $date
mango good fruit Jan 1 1900 12:00:00:000AM
.
I would like the date to show 23-10-01 instead of
Jan 1 1900 12:00:00:000AM that gets inserted as a default
any help
Caleb Carvalho
Application Engineer
LoadRunner/APM
---
-- Enterprise Testing and Performance Management Solutions
---
-- Mercury Interactive
410 Frimley Business Park
Frimley, Surrey. GU16 7ST
United Kingdom
Telephone : +44 (0)1276 808300
From: David Robley [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Caleb Carvalho [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [PHP] format date
Date: Tue, 23 Oct 2001 10:02:26 +0930
On Mon, 22 Oct 2001 22:38, Caleb Carvalho wrote:
Hi all,
i would like a simple way to get date field formatted from my little
sybase,
for some reason the output of it is showing the wrong date
example Jan 1 1900 12:00:00:000AM
thanks
Perhaps if you could show what you are doing and which is not working,
someone might be able to help you. As it is we have no idea of the format
of your data or the method you are using.
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
Politics is the entertainment branch of industry.
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] format date
-Original Message-
From: Caleb Carvalho [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 2:53 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP] format date
I am inserting into table
values('$product','$title,'$date')
the date field gets added by default, like time stamp,
Does $date have a value at this point? What is it?
when i view the contents added to database i see date field showing
ex:
display.php
$product, $title, $date
mango good fruit Jan 1 1900 12:00:00:000AM
This looks to me suspiciously like Sybase is seeing either an empty/zero
value or one that it's not able to parse as a date and time. Are you
*sure* that the column type you're using is supposed to automagically
insert a current timestamp? If so, you might double-check your
documentation to see under what circumstances it will do so...it might
only do it, for example, if you insert a NULL value (which is not the
same as an empty string). If not, you could try using the now()
function in your insert query instead of specifying a '$date' value.
---
Mark Roedel | Blessed is he who has learned to laugh
Systems Programmer | at himself, for he shall never cease
LeTourneau University | to be entertained.
Longview, Texas, USA| -- John Powell
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
FW: [PHP] format date
-Original Message-
From: Caleb Carvalho [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 2:53 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP] format date
I am inserting into table
values('$product','$title,'$date')
the date field gets added by default, like time stamp,
Does $date have a value at this point? What is it?
when i view the contents added to database i see date field showing
ex:
display.php
$product, $title, $date
mango good fruit Jan 1 1900 12:00:00:000AM
This looks to me suspiciously like Sybase is seeing either an empty/zero
value or one that it's not able to parse as a date and time. Are you
*sure* that the column type you're using is supposed to automagically
insert a current timestamp? If so, you might double-check your
documentation to see under what circumstances it will do so...it might
only do it, for example, if you insert a NULL value (which is not the
same as an empty string). If not, you could try using the now()
function in your insert query instead of specifying a '$date' value.
---
Mark Roedel | Blessed is he who has learned to laugh
Systems Programmer | at himself, for he shall never cease
LeTourneau University | to be entertained.
Longview, Texas, USA| -- John Powell
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] format date
Hi all, i would like a simple way to get date field formatted from my little sybase, for some reason the output of it is showing the wrong date example Jan 1 1900 12:00:00:000AM thanks Caleb Carvalho Application Engineer LoadRunner/APM - Enterprise Testing and Performance Management Solutions - Mercury Interactive 410 Frimley Business Park Frimley, Surrey. GU16 7ST United Kingdom Telephone : +44 (0)1276 808300 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] format date
On Mon, 22 Oct 2001 22:38, Caleb Carvalho wrote: Hi all, i would like a simple way to get date field formatted from my little sybase, for some reason the output of it is showing the wrong date example Jan 1 1900 12:00:00:000AM thanks Perhaps if you could show what you are doing and which is not working, someone might be able to help you. As it is we have no idea of the format of your data or the method you are using. -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA Politics is the entertainment branch of industry. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
