Jump to content

Archived

This topic is now archived and is closed to further replies.

bach

Data type Query

Recommended Posts

Hello,

Wonder if you can help. I am looking at the data type of the dateRegistered field for a form script I have got they are using int(10) why ?? why not date ??

Confusing me.

Cheers.

Share this post


Link to post
Share on other sites
Shouldn't be... dates should always be stored as DATEs. I guess you could get away with storing a timestamp value in a numeric field, but that's a bad idea.

Share this post


Link to post
Share on other sites
I was under the sam impression, if there isn't a good reason then I will use a date field for mine.

The forum software was

[a href=\"http://www.simplemachines.org/\" target=\"_blank\"]Simple Machine Forum[/a]

Cheers.

Share this post


Link to post
Share on other sites
You might want to use a DATETIME -- no reason to throw out half the information.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.