Property Reference > Quick Reference for All Properties > FormatTime Property |
C1Query.SQLInfo.FormatTime= string
Description
This property specifies the format string for time values applied when a constant (literal) time value is written to the generated SQL statement. The representation of the time in the SQL statement is obtained by formatting the time 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 time values, 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