Sql

Search

how to use timestampdiff in a table in sql

SELECT 
    TIMESTAMPDIFF(MONTH, '2010-01-01', '2010-06-01') result;

+--------+
| result |
+--------+
|      5 |
+--------+
1 row in set (0.00 sec)
Code language: SQL (Structured Query Language) (sql)

Comment

PREVIOUS	NEXT

Code Example
Sql :: execut sql python
Sql :: mysql remove database
Sql :: Select with remove white spaces in sql
Sql :: php delete database
Sql :: bigquery current time
Sql :: sql to linq
Sql :: on sql table data exists
Sql :: how to select all fieldsin a soql query
Sql :: sql case statement
Sql :: php insert null mysql
Sql :: best sql collation
Sql :: mariadb create view
Sql :: how to delete user sql server
Sql :: concat all rows in sql postgres
Sql :: t-sql add column
Sql :: sql date with month and year only
Sql :: declare date variable sql
Sql :: sql as
Sql :: timestamp datatype in sql
Sql :: sql select data type of query
Sql :: sqlite clear console
Sql :: frename oracle
Sql :: sql get actual fiscal year
Sql :: sql delete duplicate rows but keep one
Sql :: insert using condition postgres
Sql :: tsql generate rows
Sql :: Host ' is not allowed to connect to this MySQL server
Sql :: Write the order of execution of all the SQL clauses and statements
Sql :: insert or update cassandra
Sql :: h2 auto increment and unique

Search

SQL

how to use timestampdiff in a table in sql

ADD CONTENT