title: how to query in order of current date?
body: <p>I want to filter according to current date in flask sqlalchemy , below are my codes anytime I run it on the server it keeps giving me errors,can someone please help me.</p>
  <pre><code>class Ads(db.Model):
  
      id = db.Column(db.Integer,primary_key =True)
      condition = db.Column(db.String(255))
      phone = db.Column(db.String(233))
      category = db.Column(db.String(255))
      description = db.Column(db.String(255))
      brand = db.Column(db.String(255))
      negotiable = db.Column(db.String(255))
      price = db.Column(db.String(255))
      city = db.Column(db.String(255))
      post_by_id = db.Column(db.Integer,db.ForeignKey('user.id'))
      image = db.Column(LargeBinary)
      image_name = db.Column(db.String(255))
      mimetype =  db.Column(db.String(255))
      post_on = db.Column(DateTime(timezone=True), default=func.now())
      
  
  if  selected_page == 'electronics':
                   current_time = datetime.now()
          
                   imb = Ads.query.filter_by(category='electronics',date&gt;= current_date).paginate(per_page=20,page =page,error_out=True)
                   return render_template('electronics.html',imb=imb,prmo=prmo)
                  
  </code></pre>