Home Sql Sqldate Mysql Date Select



Mysql Date Select
Posted on: January 20, 2009 at 12:00 AM
The Tutorial elaborate an example from 'Mysql Date Select'. This section makes you easy to understand how to get the current date from your database.

Mysql Date Select

     

The Tutorial elaborate an example from 'Mysql Date Select'. This section makes you easy to understand how to get the current date from your database. The SELECT DATE ('YYYY-MM-DD') is used to return the current selected date.

SELECT DATE('2009-01-02') : The Query is used to return the specified selected date from your database as fieldname 'DATE'.

Query to select date 

SELECT DATE('2009-01-02 01:02:03');

Output 

+-----------------------------+
| DATE('2009-01-02 01:02:03') |
+-----------------------------+
| 2009-01-02 |
+-----------------------------+

Related Tags for Mysql Date Select:
sqlmysqlcdatabasedatedataselectiomakesedgettutorialreturnriathistabexamplectetobaseexamselectedesectionusefromcurrentasstamntddesasehowratetorxaxampsurnatmykismpleaandtutorssrirenthstabpleplndonomo


More Tutorials from this section

Ask Questions?    Discuss: Mysql Date Select  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.