Rossi EpvTech wrote:
> Hello,
> I'm using SQLOLEDB to connect to a MSSQL database where I've inserted
> some data using the "BULK INSERT" with the option "SET DATEFORMAT DMY".
> The SO language installed on the computer where the Sql Server and my
> programs runs is English with "Italian" as regional option.
> My connection string is :
>
> $dbh=DBI->connect("DBI:ADO: PROVIDER=SQLOLEDB.1;server=DTS03;
> DATABASE=work;Current Language=Italian",
> "$user","$pwd",{'RaiseError' => 1});
>
> well, every time I fetch a table the "date" information is returned
> in a US format instead of a Italian. it seems that the "Current
> Language" option
> doesn't work !!!!!
> How can I solve the problem?!??!
Not sure, but it seems that ADO (OLE) uses the regional settings
(on the client).
If I 'select CURRENT_TIMESTAMP', I get e.g. 2006-11-28 09:27:32,
which is the format I choose in the control panel.
Steffen
