SQLAlchemy How to load dates with timezone=UTC (dates stored without timezone)

Question

I have a model with a date column defined as :

created_on = db.Column(db.DateTime, default=db.func.now(), nullable=False)

The dates comme out with tz_info=None, which is correct, since the dates are stored without timezone info.

If I print the date :

print(my_object.created_on.isoformat())

I get this format

2014-04-26T17:46:27.353936

I would like to have a UTC timezone indicator, such as :

2014-04-26T17:46:27.353936Z

Is there a way to define this behavior in the schema config ?

SQLAlchemy has, timezone=Boolean

sqlalchemy.types.DateTime(timezone=False)

since I want the storage to be without timezone.

Vanessa Phipps · Accepted Answer · 2014-04-30 20:51:42Z

19

You want a custom data type, described here: http://docs.sqlalchemy.org/en/rel_0_9/core/types.html#custom-types

Specifically, something like this:

import pytz  # from PyPI

class AwareDateTime(db.TypeDecorator):
    '''Results returned as aware datetimes, not naive ones.
    '''

    impl = db.DateTime

    def process_result_value(self, value, dialect):
        return value.replace(tzinfo=pytz.utc)

Then just make the column like this:

created_on = db.Column(AwareDateTime, default=db.func.now(), nullable=False)

answered Apr 30, 2014 at 20:51

Vanessa Phipps

2,4091 gold badge21 silver badges23 bronze badges

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

Comments

radeklos · Accepted Answer · 2015-05-28 12:00:29Z

11

I would recommend to use Arrow type.

from datetime import datetime
from sqlalchemy_utils import ArrowType
import arrow


class Article(Base):
    __tablename__ = 'article'
    id = sa.Column(sa.Integer, primary_key=True)
    name = sa.Column(sa.Unicode(255))
    created_at = sa.Column(ArrowType)



article = Article(created_at=arrow.utcnow())

answered May 28, 2015 at 12:00

radeklos

2,25825 silver badges21 bronze badges

Collectives™ on Stack Overflow

SQLAlchemy How to load dates with timezone=UTC (dates stored without timezone)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related