date data types in database

They have: 105 posts

Joined: Mar 2006

What would be the best data type for date when a user signs up? Also, if you use time stamp how do you know what the field length should be?

He has: 1,380 posts

Joined: Feb 2002

Perhaps... date? And time would be... time? Yeah, that sounds suspiciously right.

Wink

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.