Simple date question

From: 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

« previous php.general (#112172) next »