[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] | Reference for unit 'SQLDB' (#fcl)

# DefaultSQLFormatSettings

Default settings to be used in SQL

## Declaration

Source position: sqldb.pp line 832

`const DefaultSQLFormatSettings: TFormatSettings = (CurrencyFormat: 1; NegCurrFormat: 5; ThousandSeparator: #0; DecimalSeparator: '.'; CurrencyDecimals: 2; DateSeparator: '-'; TimeSeparator: ':'; ListSeparator: ' '; CurrencyString: '$'; ShortDateFormat: 'yyyy-mm-dd'; LongDateFormat: ''; TimeAMString: ''; TimePMString: ''; ShortTimeFormat: 'hh:nn:ss'; LongTimeFormat: 'hh:nn:ss.zzz'; ShortMonthNames: ('', '', '', '', '', '', '', '', '', '', '', ''); LongMonthNames: ('', '', '', '', '', '', '', '', '', '', '', ''); ShortDayNames: ('', '', '', '', '', '', ''); LongDayNames: ('', '', '', '', '', '', ''); TwoDigitYearCenturyWindow: 50);`

## Description

DefaultSQLFormatSettings contains the default settings used when formatting date/time and other special values in Update SQL statements generated by the various TSQLConnection descendents.