database questions

[TechBoyJK]

i need to keep birthdays and IPs(among other things) in a database

for the IP i am using (varchar-16)

but im not sure if I should use datetime in a single column for member birthdays, or if I should seperate the columns into day/month/year.

 

[KLin]

Datetime is fine. There are functions that will parse the data from a datetime field if you ever needed to see them separately.

 

[TechBoyJK]

Originally posted by: KLin
Datetime is fine. There are functions that will parse the data from a datetime field if you ever needed to see them separately.

isnt there a less accurate version of datetime that takes less memory but would be fine for just day/month/year because that is really only date, of the whole datetime...

 

[HeroOfPellinor]

Originally posted by: TechBoyJK

Originally posted by: KLin
Datetime is fine. There are functions that will parse the data from a datetime field if you ever needed to see them separately.

isnt there a less accurate version of datetime that takes less memory but would be fine for just day/month/year because that is really only date, of the whole datetime...

Smalldatetime. Half as many bytes.