Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any problems using char(8) for dates in YYYMMDD
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00598911
Message ID:
00599122
Views:
17
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform