date representation in user interface
        Posted  
        
            by Samuel
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Samuel
        
        
        
        Published on 2010-03-24T17:02:00Z
        Indexed on 
            2010/03/24
            17:03 UTC
        
        
        Read the original article
        Hit count: 330
        
design
|database-design
Most of the sites capture the date (e.g. birth date) information as either a single entity (i.e via a calendar control) or instead as separate fields (date, month, year).
- Are there any benefits in showing them as separate fields?
- Are they represented in the database as DATE data type or as separate fields.
I am just trying to understand the pros & cons of representing the date field.
© Stack Overflow or respective owner