Is there a mysql unix_timestamp function in SQLAlchemy?

Question

Let me keep it simple , Is there a mysql function unix_timestamp(datetime) in SQLAlchemy ? or is there any workaround ?

codeape · Accepted Answer · 2011-07-27 08:24:30Z

5

from sqlalchemy.sql import func

for row in conn.execute(select([func.unix_timestamp("a_datetime_column")], ...)):
    # ...

answered Jul 27, 2011 at 8:24

codeape

102k26 gold badges180 silver badges201 bronze badges

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

3 Comments

can it be used for other database engines ?

No. func.NNN is a reference to a SQL function with name NNN, The db engine must support NNN. Certain function names are known by SQLAlchemy and are given special treatment, see sqlalchemy.org/docs/core/tutorial.html#functions and sqlalchemy.org/docs/core/…

How to apply this to: analys = Analyzes.query.filter_by(id=id).first()?