Simple date question
| From: | Dave Leather | Date: | Mon, 12 Aug 2002 16:34:33 +0000 |
| Subject: | Simple date question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-112172@lists.php.net to get a copy of this message | ||
I hope this is a simple date question
I am using an MSSQL database, and have a datetime field called start_date
and end_date. When I use query analyser and do a
SELECT start_date from CF_#orders
The format is
2002-08-11 12:13:44.000
In Php - my code is
<?
$qry = "Select start_date from CF_#orders";
$rs = mssql_query($qry) or die("Could not query");
$datarow = mssql_fetch_object($rs);
print $datarow->start_date;
?>
The format is now
Aug 12 2002 11:14AM
I NEEEEEED those seconds to appear in my variable.... HOW can I get the TRUE
date and time from the sql table into my variable? Is there a php.ini
variable I need to set... is there some sort of magical command????
Please help.... Thanks VERY much in advance!
Dave