Can I set date format / style on DBI ADO connection

--0-486076344-1139613263=:87340
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi,
I am using DBI ADO connection to access MS SQL Server. I switched from ODBC to ADO recently.
ADO connection is returning the date format as mm/dd/yy hh:mi:ss, where as ODBC connection returns datetime in yyyy-mm-dd hh:mi:ss(24hr) format.
A lot of code is built to handle the dates returned from queries in ODBC canonical format.
I can change all the queries using CONVERT function to return in ODBC canonical format, instead of doing that for all queries, is there anyway I can specify a date time format / style for ADO Connection, so that all the dates returned by queries will be in the format specified.
Thanks,
Kumar Talinki



--0-486076344-1139613263=:87340--

Re: Can I set date format / style on DBI ADO connection

Kumar Talinki wrote:

> Hi,
> I am using DBI ADO connection to access MS SQL Server. I switched from ODBC to ADO recently.
> ADO connection is returning the date format as mm/dd/yy hh:mi:ss, where as ODBC connection returns datetime in yyyy-mm-dd hh:mi:ss(24hr) format.
> A lot of code is built to handle the dates returned from queries in ODBC canonical format.
> I can change all the queries using CONVERT function to return in ODBC canonical format, instead of doing that for all queries, is there anyway I can specify a date time format / style for ADO Connection, so that all the dates returned by queries will be in the format specified.
> Thanks,
> Kumar Talinki

You can change the date format in the Windows Control Panel (on the
client, i.e. where your perl script runs).


Steffen