SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE lb2( col1 DATE , col2 DATETIME, col3 TIMESTAMP, col4 TIME, col5 YEAR ); INSERT INTO lb2 VALUES('2012-10-01','1265-01-08 10:30:50',CURRENT_TIMESTAMP(),'13:20:06' ,1976 ); INSERT INTO lb2 VALUES('2013-11-11','1479-03-13 11:40:20',CURRENT_TIMESTAMP(),'11:33:00' ,1986 ); INSERT INTO lb2 VALUES('2014-12-21','1337-05-25 16:35:30',CURRENT_TIMESTAMP(),'22:44:00' ,1996 ); select * from lb2; -- 1 SELECT DAYOFYEAR('1998-02-03'); SELECT DATE_ADD("1998-01-01 00:00:00", INTERVAL "-5 5" DAY_HOUR); SELECT DATE_FORMAT('1997-10-04 22:23:00', '%H %k %I %r %T %S %w'); -- 2 SELECT 1 = 5,5=5; SELECT 'wefwf' IN (0,3,5,'wefwf'); SELECT 1 && 1,1&&5,0&&5; -- 3 SELECT CONV("1111",2,16); SELECT LOCATE('sch', 'Gluschenko'); Select POSITION('ov' IN 'Gluschenko'); SELECT SOUNDEX('Bare'); SELECT SOUNDEX('Bear'); SELECT UCASE(' Gluschenko '); -- 4 SELECT SIGN(5),SIGN(0),SIGN(-5); SELECT LOG(2,65536),LOG(10,10); SELECT ATAN(-2); SELECT TRUNCATE(1.999,0), TRUNCATE(77.626,2);;