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 NEED 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