The Tutorial illustrate an example from 'Mysql Date Expression'. To understand this example we use current_timestamp query that return you a format 'YYYY-MM-DD' and 'HH.MM.SS'.

Mysql Date Expression

     

The Tutorial illustrate an example from 'Mysql Date Expression'. To understand this example we use current_timestamp query that return you a format  'YYYY-MM-DD' and 'HH.MM.SS'. Timestamp columns are displayed in the same format as Datetime format.

Query:-

 

 

 

 

 

 

mysql> select current_timestamp() as Date;

Output:-

+---------------------+ | Date | +---------------------+ | 2008-12-19 15:38:44 | +---------------------+ 1 row in set (0.00 sec)

Query:-

The now ( ) Query is used to return the current date and time as Date fieldname.

mysql> select now() as Date;

Output:-

+---------------------+ | Date | +---------------------+ | 2008-12-19 15:39:37 | +---------------------+ 1 row in set (0.00 sec)

Related Tags for Mysql Date Expression:
sql,  mysql,  c,  query,  orm,  date,  form,  time,  io,  format,  timestamp,  expression,  tutorial,  return,  ria,  this,  for,  example,  to,  express,  exam,  ssi,  e,  il,  use,  im,  from,  current,  rm,  sta,  m,  nt,  tr,  dd,  es,  me,  rate,  tor,  xa,  xamp,  s,  urn,  ess,  at,  my,  is,  ha,  ime,  ll,  mpl,  press,  pre,  and,  stamp,  str,  xp,  tutor,  s,  s,  ri,  ren,  tam,  th,  st,  hat,  ple,  pl,  pr,  nd,  on,  om,  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