MSSQL and unixtime

[Anon]

is there anyway to have MS-SQL return datetime (or even unixtime) to PHP?

I am runing MS-SQL 2000 and PHP 4.0.6 on linux - connecting via FreeTDS.

I tried to format the date with CONVERT but it always returns the date as
'Jun 09 1998 12:00AM'

SELECT CONVERT(datetime, TransDate, 100) AS thisdate FROM Mytable

thanks

[Anon]

you can start by taking your finger out of your nose. : )

[Anon]

then look what you pulled out.

select convert(varchar, getdate, 121)