Sql

##syntax: FLOOR(DATEDIFF(DATE(column_end_date), DATE(column_ini_date))/7)

Select FLOOR(DATEDIFF(DATE(20090215), DATE(20090101))/7);

PREVIOUS	NEXT

Code Example
Sql :: purge undo tablespace usage
Sql :: mysql - find in comma separated string of values
Sql :: how to search date in sql query
Sql :: simple project for database
Sql :: oracle invalid table name
Sql :: sql get month name
Sql :: sql add column int nullable
Sql :: SQL Modify Column in a Table
Sql :: mysql docker compose
Sql :: how to create new user and database postgresql in ubuntu
Sql :: sql where contains
Sql :: mysql delete user if exists
Sql :: sql delete caracter list
Sql :: table or view does not exist
Sql :: ora-01109 database not open in oracle 19c
Sql :: how to create enum in postgresql
Sql :: sql where first letter
Sql :: mssql disable foreign key constraint
Sql :: select rows with same value in a column
Sql :: change column name sql server management studio
Sql :: mysql add text to existing field
Sql :: plsql triggers
Sql :: sql count null
Sql :: mysql create database utf8
Sql :: mysql cashing error
Sql :: select nextval from sequence oracle
Sql :: mysqldump --skip-lock-tables
Sql :: select first and last row sql
Sql :: get number of table colums in sql query
Sql :: sql create view