字符串轉(zhuǎn)日期 / 轉(zhuǎn)時(shí)間戳
字符串轉(zhuǎn)日期函數(shù): str_to_date(string:timestr,string formatstr)
日期/字符串轉(zhuǎn)時(shí)間戳函數(shù):?unix_timestamp(string:timestr/date:time)
//函數(shù):str_to_date(string:timestr,string formatstr)
//函數(shù):?unix_timestamp(string:timestr/date:time)
//注意formatstr和timestr的格式,必須保持一致.
format格式說明:
日期轉(zhuǎn)字符串
函數(shù):date_format(date:time, string:formatstr)
日期比較
1 通過時(shí)間戳比較
where unix_timestamp(STR_TO_DATE('2018-05-04 12:00:00','%Y-%m-%d %H:%i:%s')) > unix_timestamp('2018-05-03 12:00:00')
2 通過函數(shù)比較
