locked
date type RRS feed

  • General discussion

  • Hello.i intend to develope a registeration site for a university and for creating it's  database there is a table

    known as persons ,that one of it's field is BirthDate.i also want that the design of my form to be somehow

    which it's birthdate part to be made of  3 seprated and independed Day,Month & Year ComboBox.

    my main problem is that i don't know whether the DataType of BirthDate field should be Date or Int?

    Tuesday, April 24, 2012 5:04 AM

All replies

  • Hello.i intend to develope a registeration site for a university and for creating it's  database there is a table

    known as persons ,that one of it's field is BirthDate.i also want that the design of my form to be somehow

    which it's birthdate part to be made of  3 seprated and independed Day,Month & Year ComboBox.

    my main problem is that i don't know whether the DataType of BirthDate field should be Date or Int?


    i want to add at the end of my sentence that the DataType even can be char(10). so what shall i do now?
    • Edited by great ehsan Tuesday, April 24, 2012 5:38 AM
    Tuesday, April 24, 2012 5:37 AM
  • It should be DATE  as you can compare/calculate Ages in the future based on the Birth Date 

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    Tuesday, April 24, 2012 7:09 AM
  • again thank you Uri.

    Tuesday, April 24, 2012 7:43 AM