Thread: date field

    #1
  1. No Profile Picture
    stefanbecker
    Guest
    Devshed Newbie (0 - 499 posts)
    Hi,

    i want to make a little birthday database. Whats the advantage of using the date field instead of a normal VARCHAR field??

  2. #2
  3. No Profile Picture
    moderator
    Guest
    Devshed Newbie (0 - 499 posts)
    From my understanding here are a few of the benefits of using a DATE column instead of a VARCHAR:

    1) a DATE column will take less disk space to store than a VARCHAR
    2) a DATE column will only accept valid dates--this provides built-in error-checking
    3) you can take advantage of MySQL's Date and Time functions easier

    However to tell you the truth I usually just use a varchar myself.

Similar Threads

  1. VB: Clearing out a date field
    By JohnnyC in forum .Net Development
    Replies: 1
    Last Post: February 12th, 2004, 08:54 AM
  2. Grabbing month/day out of a date field.
    By Zamees in forum PHP Development
    Replies: 3
    Last Post: January 30th, 2004, 02:44 PM
  3. Inserting empty date in Date field Access
    By Justin Vince in forum Database Management
    Replies: 3
    Last Post: July 22nd, 2003, 08:16 PM
  4. Deleting a field value based on date?
    By ReconClan in forum PHP Development
    Replies: 2
    Last Post: April 27th, 2003, 01:48 PM
  5. date field vs. current date
    By linuxaator in forum MySQL Help
    Replies: 1
    Last Post: February 8th, 2001, 05:50 AM

IMN logo majestic logo threadwatch logo seochat tools logo