php and mssql 's date type

[Obscurr]

hi,

I fetch a row from an MSSQL db with a field that's of type date. I'm returned
i.e. Oct 15 2003 12:00AM.
code:
$test = mssql_fetch_row($resultmail);
echo $test[0];

I want only to get the date returned and not the time i.e. Oct 15 2003.
Any clever way of doing that?

obscurr

[Tom Thackrey]

On 23-Oct-2003, ob*****@hotmail.com (Obscurr) wrote:

I fetch a row from an MSSQL db with a field that's of type date. I'm
returned
i.e. Oct 15 2003 12:00AM.
code:
$test = mssql_fetch_row($resultmail);
echo $test[0];

I want only to get the date returned and not the time i.e. Oct 15 2003.
Any clever way of doing that?

select date_format(datecolumnname,'%b %d %Y') from ...

see
http://www.mysql.com/doc/en/Date_and...functions.html

--
Tom Thackrey
www.creative-light.com
tom (at) creative (dash) light (dot) com
do NOT send email to ja*********@willglen.net (it's reserved for spammers)

[Jochen Daum]

Hi !

On 23 Oct 2003 06:01:04 -0700, ob*****@hotmail.com (Obscurr) wrote:

hi,

I fetch a row from an MSSQL db with a field that's of type date. I'm returned
i.e. Oct 15 2003 12:00AM.
code:
$test = mssql_fetch_row($resultmail);
echo $test[0];

I want only to get the date returned and not the time i.e. Oct 15 2003.
Any clever way of doing that?

select convert (datetime, column, 106) from table

or look at convert in the MSSQL help file.

HTH, Jochen
--
Jochen Daum - CANS Ltd.
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.
http://sourceforge.net/projects/phpdbedittk/