How To Use a Date Filter in an Oracle Remote View (168594)

The information in this article applies to:

Microsoft Visual FoxPro for Windows 5.0
Microsoft Visual FoxPro for Windows 5.0a
Microsoft Visual FoxPro for Windows 6.0

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.

Modification Type:	Minor	Last Reviewed:	8/30/2004
Keywords:	kb3rdparty kbDatabase kbhowto kbinterop KB168594