Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>>I'm having trouble retrieving data from an Oracle Rdb database where a date calculation is involved (eg dDischargeDate - dDob <= 18 years).
>>>>
>>>>I have very little documentation about Rdb. Please note that Rdb is a step-child of Oracle so make no Oracle assumptions!
>>>>
>>>>Is it possible to subtract 2 dates in ANSI SQL92 and get a number of days, months, or years? What is the syntax?
>>>
>>Good advice, but I need the ANSI SQL92 SPT syntax for date subtraction:
>>
>>"WHERE <= 18" && Kid is under 18 years old
>>
>>- or -
>>
>>"WHERE >>
>>I need to do subtraction since I'm looking for kids with the dx in the past 3 years so I need to calculate Dob vs discharge date.
>
>dDate = gomonth(date(), -216) && subtract 216 months from today
>
>... where Ora_DateField >= dDate
Mark, I need to retrieve discharges during the past 3 years where the patient was under 18 at the time of the discharge. So, I want to calculate _on the server_ the dob vs discharge date.
But I don't know the ANSI SQL92 syntax to do this calculation on the server. Alas, SQL92 is cryptic and doesn't have any "nice" date functions.
Otherwise, what I have done (for now) is bring back all discharges and use Fox functions locally to delete the ones I don't need.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement