Click here to Skip to main content
15,170,789 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Thought of the Day Pin
User 991608027-Aug-21 6:10
professionalUser 991608027-Aug-21 6:10 
GeneralRe: Thought of the Day Pin
jeron127-Aug-21 6:26
Memberjeron127-Aug-21 6:26 
GeneralRe: Thought of the Day Pin
Slacker00727-Aug-21 7:02
professionalSlacker00727-Aug-21 7:02 
GeneralRe: Thought of the Day Pin
Member 1532961327-Aug-21 7:24
MemberMember 1532961327-Aug-21 7:24 
GeneralRe: Thought of the Day Pin
DRHuff27-Aug-21 9:04
MemberDRHuff27-Aug-21 9:04 
GeneralRe: Thought of the Day Pin
Eddy Vluggen27-Aug-21 17:07
professionalEddy Vluggen27-Aug-21 17:07 
GeneralImposing data type and length restrictions at the database level is stupid! Pin
5teveH27-Aug-21 3:26
Member5teveH27-Aug-21 3:26 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! PinPopular
Richard Deeming27-Aug-21 3:36
mveRichard Deeming27-Aug-21 3:36 
OK, so you've stored your dates in your database as unlimited-length strings. With varying levels of "validation" on the front-end.

Now write a report based on a date range, given your table contains values such as "20190314", "1st May 2020", "32nd February 2990", "Third Sunday after Whitsun 21997", etc. Poke tongue | ;-P

And that's before you notice the significantly increased space it takes to store a string representation of a date over a proper date column.

Using proper data types in the database is precisely the kind of "straight-jacket" you want.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
5teveH27-Aug-21 4:02
Member5teveH27-Aug-21 4:02 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
obermd27-Aug-21 4:39
Memberobermd27-Aug-21 4:39 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
RickZeeland27-Aug-21 3:43
mveRickZeeland27-Aug-21 3:43 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
raddevus27-Aug-21 4:09
mvaraddevus27-Aug-21 4:09 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
User 991608027-Aug-21 5:29
professionalUser 991608027-Aug-21 5:29 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
raddevus27-Aug-21 5:44
mvaraddevus27-Aug-21 5:44 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
User 991608027-Aug-21 5:47
professionalUser 991608027-Aug-21 5:47 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
Mircea Neacsu27-Aug-21 8:11
mvaMircea Neacsu27-Aug-21 8:11 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
User 991608027-Aug-21 8:18
professionalUser 991608027-Aug-21 8:18 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
Jörgen Andersson27-Aug-21 10:07
professionalJörgen Andersson27-Aug-21 10:07 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
raddevus27-Aug-21 10:37
mvaraddevus27-Aug-21 10:37 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
Jörgen Andersson27-Aug-21 10:40
professionalJörgen Andersson27-Aug-21 10:40 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
den2k8827-Aug-21 4:22
professionalden2k8827-Aug-21 4:22 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
Jörgen Andersson27-Aug-21 10:13
professionalJörgen Andersson27-Aug-21 10:13 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
dandy7227-Aug-21 4:29
Memberdandy7227-Aug-21 4:29 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
obermd27-Aug-21 4:38
Memberobermd27-Aug-21 4:38 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
englebart27-Aug-21 4:45
professionalenglebart27-Aug-21 4:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.