title: In SQLAlchemy, how do I create a 'MySQL date' column?
body: <pre><code>class Posts(Base):
      __tablename__ = 'posts_posts'
      id = Column(Integer, primary_key = True)
      user_id = Column(Integer, nullable=False)
      body = Column(Text, nullable=True)
  
      created_at = Column(Date) &lt;&lt; is this right?
      updated_at = Column(Date) ??
  </code></pre>
  
  <p>I would also like the <code>created_at</code> column to automatically set the date when it's created.
  And also, the <code>updated_at</code> column to set the date anytime this row is changed.</p>