× 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.


  1.  Home
  2. MIDRANGE-L
  3. September 2014

Re: Converting a numeric date value to a DATE in SQL

On 09-Sep-2014 18:14 -0500, Jeff Young wrote:

The reason that I wanted to convert the database field to a DATE data
type was so that I could subtract 1 day from the value to compare to
the input variable.

It just seemed that it would be easier to do that than convert my
variable to a date format, subtracting 1 then converting back to a
decimal.

Hopefully my examples helped to portray why, what may seem /easier/ for the code, may be potentially detrimental to the ability of the query to operate efficiently [thus timely]; i.e. likely better to avoid selection on a derivation than to avoid coding [a couple] derivation(s) from a[n effective] literal.

<<SNIP>>


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.