Show current date : Date Type « Date Time « SQL / MySQL






Show current date

  
/*
mysql> SELECT CURRENT_DATE;
+--------------+
| CURRENT_DATE |
+--------------+
| 2005-10-09   |
+--------------+
1 row in set (0.00 sec)


*/  
/* SELECT CURRENT_DATE; */
SELECT CURRENT_DATE;

           
         
    
  








Related examples in the same category

1. Date and Time Sizes, Formats, and Ranges
2.Define and check the date data type
3.Define and use Date data type
4.Use date data type
5.Defining Set Membership:Finding Records in a Set
6.Performing Range Tests 3
7.Performing Range Tests 1
8.Performing Range Tests 2
9.Convert Date to int
10.The date/time data types
11.Date and Time Column Types
12.Date and Time Sizes, Formats, and Ranges