| Property Reference > Quick Reference for All Properties > FormatDate Property (SQLInfo) |
C1Query.SQLInfo.FormatDate= string
Description
This property specifies the format string for date values applied when a constant (literal) date value is written to the generated SQL statement. The representation of the date in the SQL statement is obtained by formatting the date value using the Visual Basic Format function.
Possible values for this property are all valid format strings as in the Visual Basic Format function, applicable to dates, and also two additional values:
“Default” – values are formatted using the default Windows rules (as in Visual Basic function CStr), according to the current regional settings.
“US Default” – values are formatted as in regional setting “English (United States)”.
Empty string is equivalent to “Default”.
Notes
Read/Write at run time. Unavailable at design time. Property applies to SQLInfo object. FormatDate/FormatFloat/FormatTime properties have effect only in a Visual Basic application. Using C1Query in containers other than Visual Basic, you need to use the FormatLiteral event.
See Also