Cross platform date handling

I am building a php site that is hosted on mac, linux, and windows. I am using mssql for mac/linux and sqlsrv for windows.

Most of it works fine however mssql return the date in a different format than sqlsrv. I know I can set the expected date format on the client side but would rather leave that part consistent. Can I configure the date format on the server side?

you may try ‘beforeRender’ event of the connector. It fires before the data item is writen into http output, and you can alter the values there … event.html

Or, you can customize the mssql adapter of dhtmlxConnector. The date columns are stringified explicitly, so you can change format in code … rv.php#L50