DateFormat for SQL Server

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
erpwerk
Posts: 7
Joined: Fri 12 Sep 2008 07:36

DateFormat for SQL Server

Post by erpwerk » Wed 17 Feb 2016 14:22

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
Posts: 104
Joined: Sat 18 Aug 2012 08:33

Re: DateFormat for SQL Server

Post by LHSoft » Thu 18 Feb 2016 20:01

might be with TFormatSettings ?

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: DateFormat for SQL Server

Post by azyk » Fri 19 Feb 2016 09:43

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.

Post Reply