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: 284

Filed under:
|

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).

  1. Are there any benefits in showing them as separate fields?
  2. 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

Related posts about design

Related posts about database-design