Datetime Type

[suzie]

Dear,

I have a column of "smalldatetime" Type it contains for example
31/07/2009 00:00:00 (in this format)
I want to retreive from this column using select the date only "31/07/2008" and put it in a variable like $date for example.
and then I want to get from the date the Day in string format like Wed or thu ...

How can I do that ?

Any suggestions please

thank you,

[NogDog]

What DBMS are you using (MySQL, MSSQL, PostgreSQL, etc.)? Or do you need a solution that is non-DBMS-specific?

[suzie]

Hi , I'm using Microsoft SQL Server 2000, and I'm quering from php.

thank you