dcpck2004 wrote:

> Hello,
>
> I've recently started playing with Metabase as a solution for my PHP
> database abstraction needs. I'm trying to write a project that needs
> to be portable across many different databases, and I'm hoping
> Metabase will help me do that, however...
>
> I've read the other comments about MSSQL and dates/times/timestamps
> not being translated to the ISO format. I need to get this
> functionalilty working. Is a solution in the works or already done?
> Surely it can be done either with the "convert" SQL functions or
> within PHP using regular expression manipulation? What is the best
> way to procede with getting this sorted out?

this may help:

Ini setting for output formatting:
ini_set('mssql.datetimeconvert', 'Off');

Query on startup to tell the server how input will have date parts
ordered:
SET DATEFORMAT ymd

regards,
Lukas Smith
smith@...
_______________________________
BackendMedia
www.backendmedia.com
berlin@...

Linn Zwoch Smith GbR
Pariser Str. 44
D-10707 Berlin

Tel +49 30 83 22 50 00
Fax +49 30 83 22 50 07