Hi! I never used MSSQL myself, but you should be able to find some SQL command to format the date in the MSSQL documentation - that's generally the way to retrieve specific date/time elements.
HTH Bogdan Dave Leather wrote: > 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 > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php