Horje
mysql format date Code Example
mysql format date 
DATE_FORMAT(date, format)
-- E.g.
SELECT DATE_FORMAT(dateField, '%m/%d/%Y') FROM TableName;
-- See https://www.mysqltutorial.org/mysql-date_format/ for available formats
Source: www.mysqltutorial.org
mysql pretty date format 
DATE_FORMAT(NOW(),'%M %e, %Y @ %h:%i %p') 
#Format is 'June 10, 2014 @ 06:52 PM'
mysql date format 
-- Converts 'dd.mm.yyyy' to date	(my_date_col is VARCHAR)
SELECT STR_TO_DATE(my_date_col,'%d.%m.%Y') AS my_strdate FROM my_table;
-- Converts 'dd.mm.yyyy' to 'YYYY-MM-DD'
SELECT DATE_FORMAT(STR_TO_DATE(my_date_col,'%d.%m.%Y'), '%Y-%m-%d') AS my_strdate
	FROM my_table;
Source: www.tutorialspoint.com
date format mysql 
DECLARE df VARCHAR(20);
DECLARE dt VARCHAR(20);

SET df = DATE_FORMAT(_Datefrom,'%Y-%m-%d 00:00:00'); 
SET dt = DATE_FORMAT(_DateTo,'%Y-%m-%d 23:59:59');




Related
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Code Example ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Code Example
rename table sql Code Example rename table sql Code Example
mysql show all tables Code Example mysql show all tables Code Example
mysql show tables in database Code Example mysql show tables in database Code Example
how to auto increment in sql Code Example how to auto increment in sql Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 9



 

Horje