mysql 字符串转时间 和 时间转时间戳

SELECT * FROM pub_project 
# SELECT STR_TO_DATE(列名,时间格式) 字符串转时间	to_days ()  时间转时间戳
WHERE to_days((SELECT STR_TO_DATE(START_TIME,'%Y-%m-%d'))) = to_days(now())

to_days(creationTime) = to_days(now())


#------------------------------------------------------------------

SELECT per.id as 考场编号,per.CLASS_ROOM as 考场名称,per.BEGIN_TIME as 考场开始时间
,per.END_TIME as 考场结束时间 ,
#时间转换
(SELECT STR_TO_DATE(per.BEGIN_TIME,'%Y-%m-%d %H:%i:%s')) , (SELECT STR_TO_DATE('2018-11-20 13:50:30','%Y-%m-%d %H:%i:%s'))

,pcr.ID as 教室编号, pcr.CLASS_ROOM as 教室名称
FROM pub_exam_room per 
INNER JOIN pub_eaxm_class_room pecr ON pecr.exam_id=per.id 
RIGHT JOIN pub_class_room pcr on pcr.ID = pecr.ROOM_ID