date format from MS SQL

[tik]

I'm using MS SQL not mysql

If I run the following query:

$sql = "select getdate() as date";
$result = mssql_query($sql, $link) or die( "ERROR: Query failed");

in php "date" equals:
Mar 27 2007 10:39PM

in Query Analyzer "date" equals:
3/27/2007 10:39:26 PM

First, I hate the format php displays, can I change it to the same as Query Analyzer?
Second, as you can see php drops the seconds and I need them, how can i keep them?

Thanks

tk

[Piranha]

The [man]date[/man] function can be used to format dates.

[Weedpacket]

PHP doesn't have a "date format". That's something you specify.

If you mean that "Mar 27 2007 10:39PM" is what you get from the database when you select a date field, then that's the responsibility of the database query/server, not PHP.

See the user notes on the [man]mssql_query[/man] page.