DateFormat for SQL Server

[erpwerk]

Hello,

we are using UniConnection, SQLServerUniProvider and UniQuerys
and try to change the date format.
UniQuery.fieldByName('date').asDateTime;

We get the format 'YYYY-MM-DD' but need 'DD.MM.YYYY'.

The options DateFormat and TimedFormat are not available at 'SQL Server'.

Is there an easy way to change all querys at once?

UniDAC 4.3.8 for Delphi 7

[LHSoft]

might be with TFormatSettings ?

[azyk]

Please try to compose a small sample, in which specify the place where you need to change the date format to 'DD.MM.YYYY' for all the queries. (For query parameters / on generating SQL queries / on displaying data grid / etc.). Send this sample, including scripts for creating test tables, to andreyz*devart*com.