. .

Y2K (2000 ) Date MySQL

» PHP » MySQL » Y2K (2000 ) Date MySQL

MySQL 2-, - . , 2 , , . 4 , MySQL , .

DATETIME, DATE, TIMESTAMP YEAR MySQL :

  • 00 69 2000 2069;
  • 70 99 1970 1999.

, , . , MySQL, , , 4 .

, ORDER BY YEAR, DATE DATETIME 2 .

, , MIN() (), TIMESTAMP DATE . , timestamp 2 . TIMESTAMP DATE 4 MIN(DATE_ADD (timestamp, INTERVAL DAYS)).