Microsoft KB Archive/168594: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (Text replacement - ">" to ">") |
||
Line 60: | Line 60: | ||
The following example filter criteria returns all records from the table where the date field contains a date later than January 1, 1996: | The following example filter criteria returns all records from the table where the date field contains a date later than January 1, 1996: | ||
<pre class="codesample"> Date_Field | <pre class="codesample"> Date_Field > '1996-01-01 00:00:00' | ||
</pre> | </pre> | ||
NOTE: The time portion of this date must be included. If the time is not needed, use 00:00:00 as the time portion of the datetime expression as in the above example. | NOTE: The time portion of this date must be included. If the time is not needed, use 00:00:00 as the time portion of the datetime expression as in the above example. |
Latest revision as of 20:24, 20 July 2020
Article ID: 168594
Article Last Modified on 8/30/2004
APPLIES TO
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 5.0a
- Microsoft Visual FoxPro 6.0 Professional Edition
This article was previously published under Q168594
SUMMARY
When you use a date field as a filter criteria in a remote view to an Oracle table, the date value must be specified using the following format:
'YYYY-MM-DD HH:MM:SS'
MORE INFORMATION
The following example filter criteria returns all records from the table where the date field contains a date later than January 1, 1996:
Date_Field > '1996-01-01 00:00:00'
NOTE: The time portion of this date must be included. If the time is not needed, use 00:00:00 as the time portion of the datetime expression as in the above example.
Keywords: kbhowto kbinterop kbdatabase kb3rdparty KB168594