Jump to content

Archived

This topic is now archived and is closed to further replies.

stockton

MSSQL datetime and PHP getdate()

Recommended Posts

I am attempting using the result of getdate() as a key to a MSSQL database. The MSSQL index is a SQLDATETIME.
I use :-
$StartDate = getdate();
and after connecting and selecting the database
mssql_bind($proc, "@StartDate", $StartDate, SQLDATETIME);

This fails. Is there something I need to do to the variable I get from getdate() before making the MSSQL call?

Share this post


Link to post
Share on other sites
I found that using $Datum = date("'Y-m-d H:i:s'"); rather than getdate() worked fine.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.