4D v13.4
odbc_constant
- 4D SQL Reference
-
- Syntax rules
-
- Syntax rules
- 4d_function_call
- 4d_language_reference
- all_or_any_predicate
- arithmetic_expression
- between_predicate
- case_expression
- column_definition
- column_reference
- command_parameter
- comparison_predicate
- exists_predicate
- foreign_key_definition
- function_call
- in_predicate
- is_null_predicate
- like_predicate
- literal
- predicate
- primary_key_definition
- search_condition
- select_item
- sort_list
- sql_data_type_name
- sql_name
- sql_string
- subquery
- table_constraint
- table_reference
- odbc_constant
4D v13.4
odbc_constant
odbc_constant
|
{constant_type 'value'} |
||
An odbc_constant is a sequence of characters containing a date and/or time constant value formatted according to the ODBC API:
| constant_type | value | Description |
| d | yyyy-mm-dd | Date only |
| t | hh:mm:ss[.fff] | Time only |
| ts | yyyy-mm-dd hh:mm:ss[.fff] | Date and time (timestamp) |
Note: fff indicates milliseconds.
For example, you can use the following constants:
{ d '2013-10-02' }
{ t '13:33:41' }
{ ts '1998-05-02 01:23:56.123' }
PROPERTIES
Product: 4D
Theme: Syntax rules
© 1985-2013 4D SAS / 4D, Inc. All rights reserved.