The following sections contain descriptions of some of the more powerful SQL statements that are supported by the database interface.
Literal expressions used in assignments and comparisons can be of character, numeric or date format. Character strings are single quote delimited. In general, dates can be queried as follows:
- For ODBC —
SELECT * FROM <table> where <date_field> >
The date format through ODBC depends upon the setting of the OpenUtilities Substation configuration variable MS_DBODBCDATEFORMAT. It is set to mm/dd/yyyy by default. The variable is stored in the odbc.cfg file located in the ..\<product_name>\config\database\.
- For Oracle (direct
SELECT* FROM <table> where <date_field> >
The date format in Oracle is dependent upon the NSL_DATE_FORMAT setting. You must use the following statement keyed in through the SQL Window or the SQL statement portion of VSQL to alter the format (substitute the format you require for mm/dd/yyyy):
alter session set nls_date_format = 'mm/dd/yyyy'