Microsoft KB Archive/168594

= How To Use a Date Filter in an Oracle Remote View =

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.