PHP ODBC Date Insert into Access

[sn0rcha]

Heya's

I was wondering if someone could shed some light a problem. I am trying to insert specific dates into a date/time field in ms access using php. In cold fusion you can use a function called "createodbcdatetime(var)" - Is there a similar function in PHP?

Cheers
Snorcha

 

[streetbmx]

In PHP, with ODBC I think your Access database can not have a date field. It should be a regular text field. As for getting the date in PHP use the date function, something like this:

$date = date('h:ia m/d/y');

http://www.php.net/manual/en/function.date.php