mssql function to convert DATETIME field

[Anon]

Hello all.

Im having problems getting the date from a DATETIME field in a MSSQL database, using PHP functions ...

When I look into PHPmyAdmin, the field 'date' is shown like this ;

'2002-05-01 23:32:28.000'

However, if I output this filed in a PHP script, the date will automatically converted into this ;

'May 1 2002 11:32PM'

Im missing the seconds here, and I figured out that if I could get the result from my MSSQL query automatically converted into a unix timestamp, my problems would be solved ...

Is there a MSSQL function that can to this ? That I would apply directly into my select query ?

Thanks for any help guys =)

[mikesgt2]

Instead of using the DATETIME type you could just store the unix timestamp in the database.