Mysql Date no Time

Mysql Date no Time is used to find out the current date with no time.

Understand with Example

The Tutorial illustrate an example 'Date no Time' in Mysql . In this Example, the date(now( ) ) return you the current date  with no time.

date(now( ) ) : The date(now( ))  return you the current year, month and date.

Query:-

mysql> select date(now())as Date;

Output:-

+------------+
| Date       |
+------------+
| 2008-12-22 |
+------------+
1 row in set (0.00 sec)

Related Tags for Mysql Date no Time:
sql,  mysql,  c,  date,  time,  tutorial,  return,  ria,  this,  example,  with,  to,  exam,  e,  il,  it,  im,  current,  in,  no,  m,  nt,  tr,  me,  rate,  tor,  xa,  xamp,  s,  urn,  at,  my,  is,  ime,  ll,  mpl,  str,  tutor,  s,  s,  ri,  ren,  th,  st,  ple,  pl,  o

More Tutorials from this section

• SQL Date, SQL Date Examples
• SQL Date
• MySQL By Date
• MySQL By Week
• Mysql date API
• Mysql Date Arithmetic
• Mysql Date in between
• Mysql Date Default
• Mysql date equal
• Mysql date field
• Mysql Date Filter
• Mysql Date Format codes
• Mysql Date Format Convert
• Mysql Date Format
• Mysql Date from Date
• Mysql Date and Time
• Mysql Date Functions
• Mysql Date Index
• Mysql Date Input
• Mysql Date To Java Date

Ask Questions?    Discuss: Mysql Date no Time  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):