search

WordPoints / wordpoints

Points plugin for WordPress
GNU General Public License v2.0
20 stars 15 forks source link

Date data types #568

Open JDGrimes opened 7 years ago

JDGrimes commented 7 years ago

Introduce date data types, and also hook conditions relating to them.

See https://github.com/WordPoints/buddypress/issues/1#issuecomment-242832836

JDGrimes commented 7 years ago

We've already indicated that mysql_datetime is reserved, in the developer docs. Now I think we should reserve the Unix timestamp data type as well. It is an integer, of course, (or actually, it could be stored as a string as well), but it conveys a particular type of data, not just number-line based data. So it is a distinct data type (just like the MySQL DATETIME is a string under the hood). I'm not sure whether we should go with unix_timestamp or just timestamp as the slug. I guess that it is best to be unambiguous, and unix_timestamp also matches the general format of mysql_datetime as a slug. So let's go with that.

JDGrimes commented 7 years ago

Dealing with timezones will be fun. And likely important.