ANSI SQL Date Calculations against Oracle Rdb data

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

ANSI SQL Date Calculations against Oracle Rdb data

Message

21/07/1999 15:48:21

Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

ANSI SQL Date Calculations against Oracle Rdb data

Divers

Thread ID:

00244314

Message ID:

00244314

Vues:

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?

Répondre

Fil

Voir

Click here to load this message in the networking platform