Date queries in SQL*Forms

From: Tommy Wareing <p0070621_at_oxford-brookes.ac.uk>
Date: 3 Nov 1993 12:47:51 -0600
Message-ID: <CFxD4w.EGH_at_uk.ac.brookes>


We've got a form which has a date field in the format MON-YY (since the users don't care about the day of the month).

But, any queries on this field produce fewer rows than we'd like, since the default conversion assumes the 1st day of the month (ie. a query on SEP-93 is actually a query on 01-SEP-1993 00:00:00).

Having experimented, we found that replacing the first character of the month with a % almost works, in that it converts the database value to a character string and then uses LIKE to compare them.

This is horrible though, and automating it with a pre-query trigger is unreliable.

Does anyone know how to tidy this up?

It's Forms 3 under Oracle 6 btw.

--
  _________________________   __________________________________________
 /  Tommy Wareing          \ /  In the beginning, there was The Bomb    \
|  p0070621_at_brookes.ac.uk   X   And The Bomb said "Let there be Light!"  |
 \  0865-483389            / \     - The Bomb, Dark Star                /
  ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Wed Nov 03 1993 - 19:47:51 CET

Original text of this message