×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
IOW you really need to tell us the two fields you are comparing. But,
I'll take a guess, as Paul did, that you are trying to compare a true date
field (current date) against a packed decimal column from your database.
There's many ways to slay this dragon. There's a big performance
difference in it.
Converting current date to numeric
will often perform better than
converting db2 column to a date field
because it can continue to use existing indexes and whatnot. That, and
there's only one conversion involved.
See idate at
http://www.think400.dk/downloads.htm
For easy date conversions with error checking.
Rob Berendt
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
