mysql> create table testtime(id int auto_increment not null,timestr int,PRIMARY KEY(id));Query OK, 0 rows affected (0.01 sec)mysql> desc testtime;+---------+---------+------+-----+---------+----------------+| Field   | Type    | Null | Key | Default | Extra          |+---------+---------+------+-----+---------+----------------+| id      | int(11) | NO   | PRI | NULL    | auto_increment || timestr | int(11) | YES  |     | NULL    |                |+---------+---------+------+-----+---------+----------------+2 rows in set (0.01 sec)mysql> insert into testtime(timestr) values(UNIX_TIMESTAMP(‘2014-06-01 21:00:00‘));Query OK, 1 row affected (0.00 sec)mysql> select FROM_UNIXTIME(timestr) from testtime;+------------------------+| FROM_UNIXTIME(timestr) |+------------------------+| 2014-06-01 21:00:00    |+------------------------+1 row in set (0.00 sec)mysql> 

mysql> select LOWER(title) from film limit 4\G*************************** 1. row ***************************LOWER(title): academy dinosaur*************************** 2. row ***************************LOWER(title): ace goldfinger*************************** 3. row ***************************LOWER(title): adaptation holes*************************** 4. row ***************************LOWER(title): affair prejudice4 rows in set (0.00 sec)