SELECT CURDATE();		//DATA
SELECT CURTIME();		//CZAS
SELECT NOW();			//Data i czas
SELECT UNIX_TIMESTAMP(); 	//Czas unixowy
SELECT CURDATE() + 0 		//Czas w postaci liczbowej

DODAWANIE DNIA (3 sposoby)
SELECT ADDDATE('2010-01-01', INTERVAL 1 DAY);
SELECT DATE_ADD('2010-01-01', INTERVAL 1 DAY);
SELECT '2010-01-01' + INTERVAL 1 DAY;

ODEJMOWANIE DNIA (4 sposoby)
SELECT ADDDATE('2010-01-01', INTERVAL -1 DAY);
SELECT DATE_ADD('2010-01-01', INTERVAL -1 DAY);
SELECT '2010-01-01' - INTERVAL 1 DAY;
SELECT DATE_SUB('2010-01-01', INTERVAL 1 DAY);

select datediff (curtime(), data_wpisu) from tejestry;

select timestampdiff(year,data_wpisu,curdate()) as "rok" from rejestry;
select timestampdiff(month,data_wpisu,curdate()) as "rok" from rejestry;
select timestampdiff(day,data_wpisu,curdate()) as "rok" from rejestry;