MYSQL中保存为整数的TIMESTAMP时间戳处理一例(国外英文资料).doc

MYSQL中保存为整数的TIMESTAMP时间戳处理一例 In MYSQL, when the TIMESTAMP time stamp is saved in integers such as int (10), the result of the direct query is the form 1377265922. At this point, the processing of the date is difficult, and the next example will solve the problem of adding and subtracting the date. The query is a date form where enterdate is the TIMESTAMP value of int (10) : Select id, from_unixtime (enterdate) from b_titles where from_unixtime (enterdate) = 2012-09-1500:15 And from_unixtime (enterdate) = 2012-09-16 23:59:15 order by id; Select id, from_unixtime (enterdate) and YEAR (from_unixtime (enterdate)), MONTH (from_unixtime (enterdate)), DAY (from_unixtime (enterdate)), HOUR (from_unixtime (enterdate)), MINUTE (from_unixtime (enterdate)), SECOND (from_unixtime (enterdate)) from b_titles where id = 86 and id = 226 order by id. The record for the id = 86 and id = 126 will reduce its enterdate date by 6: Update b_titles set enterdate = UNIX_TIMESTAMP (from_unixtime (enterdate), INTERVAL 6)) where id = 86 and id = 126; The record for the id = 86 and id = 126 is the date of the enterdate date plus 3: Update b_titles set enterdate = UNIX_TIMESTAMP (from_unixtime (enterdate), INTERVAL 3 DAY)) where id = 86 and id = 126; The record for the id = 86 and id = 126 will subtract 1 from the date of enterdate: Update b_titles set enterdate = UNIX_TIMESTAMP (from_unixtime (enterdate), INTERVAL 1 YEAR)) where id = 86 and id = 126; Attachment: the TIMESTAMP TIMESTAMP that is saved as an integer can be handled arbitrarily with the date function in the back. DAYOFWEEK (date) The return date date of date (1 = Sunday, 2 = Monday,... 7 = Saturday). These index values correspond to the ODBC standard. Mysql select DAYOFWEEK ( 1998-02-03 ); - 3 WEEKDAY (date) Returns the week index of date (0 = Monday, 1 = Tuesday,... 6 = Sunday). Mysql select WEEKDAY ( 1997-10-04 22:23:00 ); - 5 Mysql select WEEKDAY ( 1997-11-05 ); - 2 DAYOFMONTH (date) The date of the month tha