/SQL/Mysql compare datetime to another datetime

Mysql compare datetime to another datetime

Mysql compare datetime to another datetime

Select * From temp where mydate > '2009-06-29 04:00:44';

2

Mysql compare datetime to another datetime

Select * From temp where mydate > STR_TO_DATE('2009-06-29 04:00:44', '%Y-%m-%d %H:%i:%s');

0

Similar codes

9 votes116 views1 answer
No sql
SQL
0 vote131 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
-1 vote127 views4 answers
Restart mysql server ubuntu
SQL
15 votes114 views4 answers
How to get all tables in sql
SQL
0 vote126 views1 answer
Ubuntu connect to mssql database
SQL
6 votes121 views2 answers
Join vs union
SQL
2 votes125 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote116 views1 answer
How to select even id in sql
SQL
1 vote125 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote114 views1 answer
How to create a new db from dumb file mysql
SQL

Share