Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oracle Sql Statement
Message
 
 
Information générale
Forum:
Oracle
Catégorie:
Autre
Divers
Thread ID:
00802182
Message ID:
00802241
Vues:
34
Since you are just looking for 1 date, 12/13/1971, you could just write your SQL this way:

SELECT * FROM VOTER ;
WHERE tdob = to_date('12/31/1971', 'MM/DD/YYYY') ;
AND cvotstatus = 'A'

As for yuor observed performance difference, it is always better to use BETWEEN when a column value needs to be between 2 other values.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform