This Example create mysql retrieves and displays TIME values in 'HH:MM:SS' format but HHMMSS format it makes sense as a time for example "101112".

Mysql Time Type

     

This Example create  mysql retrieves and displays TIME values in 'HH:MM:SS' format but HHMMSS format it makes sense as a time for example "101112".

 

 

 

 

 

 

Database Table "timeTable":

CREATE TABLE `timetable` (  `id` bigint(20) NOT NULL auto_increment,  `time_field` time default NULL,  PRIMARY KEY (`id`)  )

Query to select  time values :

select time_field from timeTable;

Output :

+------------+ | time_field | +------------+ | 10:10:10 | +------------+ 1 row in set (0.00 sec)

Related Tags for Mysql Time Type:
sql,  mysql,  c,  orm,  form,  time,  make,  format,  display,  value,  this,  create,  for,  ie,  example,  values,  exam,  e,  it,  mms,  spl,  trie,  im,  in,  rm,  as,  m,  play,  tr,  isp,  es,  retrieve,  me,  xa,  xamp,  s,  sp,  displays,  at,  my,  k,  is,  hmm,  ime,  mpl,  ea,  and,  va,  s,  s,  ri,  th,  12,  alu,  disp,  ple,  pl,  nd,  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