format_spec
The FORMAT clause of the COLUMN section in the Omnidex Environment file applies to Omnidex Date class data types. This includes OMNIDEX DATE, OMNIDEX DATETIME and OMNIDEX TIME.
In the INTERNAL section of the COLUMN section, this refers
to the actual data stored in the database.
If the data type
of the actual data in the database is an Omnidex Date class data type,
use this clause to indicate the granularity of the data. For example,
if the data type is OMNIDEX DATE and only the year and month are stored
in the database, the format_spec would be: YYYYMM or YYMM.
In the OMNIDEX section of the COLUMN section, this refers
to what is stored in the index files.
No matter what
the data type of the database date data is, the Omnidex indexes store
only Omnidex Date class data. Use the FORMAT format_spec clause to define
the granularity of the data stored in the index files. For example, if
the database data type is ORACLE DATETIME but you only want to search
on the date, there is no need to store the time portion in the indexes.
The format_spec could be: YYYYMMDD.
NOTE: This clause DOES NOT affect the appearance of returned data.
Valid Formats
Date formats are based on the following:
YYYYMMDDHHNNSSFF |
Where: |
YYYY |
long year - 1941, 2005 |
YY |
short year - 41, 05 |
MM |
month from 01 to 12 - June = 06 |
DD |
day from 01 to 31 |
HH |
hour from 00 to 23 |
NN |
minute from 00 to 59 |
SS |
second from 00 to 59 |
FF |
fraction of a second from 0.01 to 0.99 |
Date formats can can be any of the following: