FormatDateTime in PHP

[John K]

I recently took a job doing PHP but come from an ASP background. I'm
trying to find a conversion equivalent for VBScript's "formatdatetime ".

All I want to do is convert a MySQL datetime field into a long date.
e.g. 2006-01-30 to January 1, 2006.
PLEASE provide an example that I can use as a future benchmark so I can

understand the syntax better. I really need to learn PHP and I'm a
little freaked out right now.
Thanks!

[Kevin H. Feeley]

John K wrote:

I recently took a job doing PHP but come from an ASP background. I'm
trying to find a conversion equivalent for VBScript's "formatdatetime ".

All I want to do is convert a MySQL datetime field into a long date.
e.g. 2006-01-30 to January 1, 2006.
PLEASE provide an example that I can use as a future benchmark so I can

understand the syntax better. I really need to learn PHP and I'm a
little freaked out right now.
Thanks!

2006-01-30 can be converted to "January 1, 2006" using
date("F j, Y",mktime(0,0,0 ,01,30,2006));
Or, you can accomplish the same task with variables stuck into the mktime
function:
date("F j, Y",mktime($hour ,$minute,$secon d,$month,$day,$ year));

Kevin

[Scot McConnaughay]

http://www.php.net/manual/en/ is a great place to start learning PHP.
Also, they have a function search on that page which allows you to
search for functions... The search input field has an auto-complete
feature to help you find the function you wish to locate.

Good Luck at your new job!

Scot

John K wrote:

I recently took a job doing PHP but come from an ASP background. I'm
trying to find a conversion equivalent for VBScript's "formatdatetime ".

All I want to do is convert a MySQL datetime field into a long date.
e.g. 2006-01-30 to January 1, 2006.
PLEASE provide an example that I can use as a future benchmark so I can

understand the syntax better. I really need to learn PHP and I'm a
little freaked out right now.
Thanks!

--
Scot McConnaughay

[Greg Scharlemann]

John K wrote:

All I want to do is convert a MySQL datetime field into a long date.
e.g. 2006-01-30 to January 1, 2006.

I recently asked a similar question. See if this thread helps:
http://groups.google.com/group/comp....00282f2d660cca

greg

[John K]

This is how I'm trying to do this at the moment, I should have included
this first, sorry.

<?php require_once('C onnections/hthConnect.php' ); ?>
<?php
mysql_select_db ($database_hthC onnect, $hthConnect);
$query_gigRecal l = "SELECT tbl_gigs.fld_gi g_Date,
tbl_gigs.fld_gi g_Time, tbl_gigs.fld_gi g_Title, tbl_gigs.fld_gi g_Place
FROM tbl_gigs WHERE tbl_gigs.fld_gi g_Date >= CURDATE()";
$gigRecall = mysql_query($qu ery_gigRecall, $hthConnect) or
die(mysql_error ());
$row_gigRecall = mysql_fetch_ass oc($gigRecall);
$totalRows_gigR ecall = mysql_num_rows( $gigRecall);
?>
<span class="midYello wCaps"><?php echo $row_gigRecall['fld_gig_Title'];
?></span><br>
HERE WHERE I'M TRYING TO FORMAT THE DATE BELOW
<?php echo $row_gigRecall['fld_gig_Date']; ?> at <?php echo
$row_gigRecall['fld_gig_Time']; ?>

[Justin Koivisto]

John K wrote:

This is how I'm trying to do this at the moment, I should have included
this first, sorry.

<?php require_once('C onnections/hthConnect.php' ); ?>
<?php
mysql_select_db ($database_hthC onnect, $hthConnect);
$query_gigRecal l = "SELECT tbl_gigs.fld_gi g_Date,
tbl_gigs.fld_gi g_Time, tbl_gigs.fld_gi g_Title, tbl_gigs.fld_gi g_Place
FROM tbl_gigs WHERE tbl_gigs.fld_gi g_Date >= CURDATE()";
$gigRecall = mysql_query($qu ery_gigRecall, $hthConnect) or
die(mysql_error ());
$row_gigRecall = mysql_fetch_ass oc($gigRecall);
$totalRows_gigR ecall = mysql_num_rows( $gigRecall);
?>
<span class="midYello wCaps"><?php echo $row_gigRecall['fld_gig_Title'];
?></span><br>
HERE WHERE I'M TRYING TO FORMAT THE DATE BELOW
<?php echo $row_gigRecall['fld_gig_Date']; ?> at <?php echo
$row_gigRecall['fld_gig_Time']; ?>

Why not just retrieve the date in that format with the query?
http://dev.mysql.com/doc/refman/5.0/...functions.html

SELECT

DATE_FORMAT('%M %e, %Y',tbl_gigs.fl d_gig_Date) as fld_gig_Date,

tbl_gigs.fld_gi g_Time, tbl_gigs.fld_gi g_Title, tbl_gigs.fld_gi g_Place
FROM tbl_gigs WHERE tbl_gigs.fld_gi g_Date >= CURDATE()

--
Justin Koivisto, ZCE - ju****@koivi.co m
http://koivi.com

[Kimmo Laine]

"John K" <ki*****@yahoo. com> kirjoitti
viestissä:11*** *************** ****@f14g2000cw b.googlegroups. com...

I recently took a job doing PHP but come from an ASP background. I'm
trying to find a conversion equivalent for VBScript's "formatdatetime ".

All I want to do is convert a MySQL datetime field into a long date.
e.g. 2006-01-30 to January 1, 2006.

$unixTimeStamp = strtotime('2006-01-30');
date('F d, Y', $unixTimeStamp) ;

Returns January 30, 2006
--
SETI @ Home - Donate your cpu's idle time to science.
Further reading at <http://setiweb.ssl.ber keley.edu/>
Kimmo Laine <an************ *******@gmail.c om.NOSPAM.inval id>

[John K]

I tried it didn't produce a result (the date that is). Time produced
result however.

This is what I put in. Did I do something wrong?

<?php
mysql_select_db ($database_hthC onnect, $hthConnect);
$query_gigRecal l = "SELECT DATE_FORMAT('%M %e,
%Y',tbl_gigs.fl d_gig_Date) as fld_gig_Date, tbl_gigs.fld_gi g_Time,
tbl_gigs.fld_gi g_Place FROM tbl_gigs";
$gigRecall = mysql_query($qu ery_gigRecall, $hthConnect) or
die(mysql_error ());
$row_gigRecall = mysql_fetch_ass oc($gigRecall);
$totalRows_gigR ecall = mysql_num_rows( $gigRecall);
?>

[Justin Koivisto]

John K wrote:

I tried it didn't produce a result (the date that is). Time produced
result however.

This is what I put in. Did I do something wrong?

<?php
mysql_select_db ($database_hthC onnect, $hthConnect);
$query_gigRecal l = "SELECT DATE_FORMAT('%M %e,
%Y',tbl_gigs.fl d_gig_Date) as fld_gig_Date, tbl_gigs.fld_gi g_Time,
tbl_gigs.fld_gi g_Place FROM tbl_gigs";
$gigRecall = mysql_query($qu ery_gigRecall, $hthConnect) or
die(mysql_error ());
$row_gigRecall = mysql_fetch_ass oc($gigRecall);
$totalRows_gigR ecall = mysql_num_rows( $gigRecall);
?>

maybe it has to do with the name... try this instead:

DATE_FORMAT('%M %e, %Y',tbl_gigs.fl d_gig_Date) as formatGigDate

and then:
<?php echo $row_gigRecall['formatGigDate']; ?>

--
Justin Koivisto, ZCE - ju****@koivi.co m
http://koivi.com

[John K]

THAT DID IT, THANK YOU!!!! YES!