Deprecated: Assigning the return value of new by reference is deprecated in /www/htdocs/w00b4663/includes/classes/external/database/database.php on line 166

Deprecated: Function ereg() is deprecated in /www/htdocs/w00b4663/includes/classes/external/database/database.php on line 329
Sql » aktuellesdatum.de

 

Aktuelles Datum in den Programmiersprachen PHP, JAVA, C, C++, C#, Excel
 

 

aktuellesdatum.de » Sql
 

Start

 

Sql

Aktuelles Datum in SQL: 
SELECT field1,field2 FROM TABLE WHERE DATE_FORMAT(datum, '%Y%m%d')=DATE_FORMAT(NOW(),"'%Y%m%d'");
Alternativ: 
SELECT field1, field2 FROM TABLE WHERE date = CURDATE();