Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Any problems using char(8) for dates in YYYMMDD
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
00598911
Message ID:
00599122
Vues:
18
>Should not occur problems when retrieving reports.
>Note that you will need additional trnasformations from Date type to char(8) and you will possibly need additional coding for date verification.
>:) nice idea... we do not do it this way... but will think about such approach :)

Why wouldn't this be just DTOC(dDateVar,1) ?
It won't even need an extra column; just in the index.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform