Extract on date : django.db.utils.OperationalError: near "None": syntax error

Question

I try to format the date in a query, but I got an error whentrying to extract the year, the month...

This occurs on sqlLite and Postgres.

Django version : 1.11.4

>>> users = User.objects.all()
>>> users.annotate(year=Cast(ExtractYear('date_joined'), CharField()))

return Database.Cursor.execute(self, query, params)
sqlite3.OperationalError: near "None": syntax error

Eugene Kovalev · Accepted Answer · 2018-07-04 14:03:43Z

2

It's really weird. It couldn't cast even ID of users like: users.annotate(year=Cast('id', CharField()))

Solution:

Try using TextField like: users.annotate(year=Cast(ExtractYear('date_joined'), TextField())) instead of CharField

answered Jul 4, 2018 at 14:03

Eugene Kovalev

3,8771 gold badge18 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Aurélien Over a year ago

Indeed, replacing the CharField with the TextField did the trick, thanks.

Collectives™ on Stack Overflow

Extract on date : django.db.utils.OperationalError: near "None": syntax error

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related