Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to store year in Django

Tags:

mysql

django

What would be the best way to store year (YYYY) in a django model? I'm using a mysql backend.

start_year = models.SmallIntegerField(blank=True, null=True)

??

like image 693
David542 Avatar asked Apr 29 '13 20:04

David542

1 Answers

On second thought, since you're storing years, make it nonnegative.

start_year = models.PositiveSmallIntegerField(blank=True, null=True)
like image 160
Chris Avatar answered Nov 03 '22 07:11

Chris
Sign in to Comment

Related questions

How to display image from database in CodeIgniter?
How to model cities with aliases in MySQL
How to import Access 2010 database (.accdb) into MySQL [duplicate]
Best way to make a PDO mysql static connection class?
How to submit a form inside a jQuery Mobile page?
Migrate rows for import into existing Database, taking care of changing ids etc
Writing a MySQL database find/replace script in PHP
Cant set mysql timezone to madrid
Disabling committing object changes in SQLAlchemy
Cannot get django-activity-stream database tables installed
MySQL is not using INDEX in subquery
Update a row if exists, if not create a new one MySQL
MySQL 5.5 losing trailing spaces in query
mysql date show results today/yesterday/week
ON DELETE CASCADE option not in generated when using ddl schema generation on Mysql
Wildcard searching of encrypted data in a MySQL database?
Data set creation for eventual integration into MySQL & Google Maps API for a website? (a la point-in-polygon, collision theorem, etc)
Replacing Subqueries with Joins in MySQL
Force MySQL to use only unix socket
MAMP Pro Error: The MySQL configuration file my.cnf couldn't be written

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!