SQL time format conversion in MySQL

From_unixtime (unix_timestamp, format) converts the timestamp to the specified format As:select from_unixtime (addtime, '%y-%m-%d%h:%i:%s ') as DateTime From Table1unix_timestamp ([datetime]) converts datetime to timestamp as:select from_unixtime ([Addday]) as Unixtime from Table1case (value As type) convert (value, type) converts the specified value and type to the specified type and produces the corresponding value where the type (type) is as follows: Signed: integer unsigned: unsigned integer decimal: floating-point datetime: Date type Time: Date: DateTime char (): Character type, can be binary as:select cast (' 123abc ' as signed) as Res; To integer 123--------------select CONVERT (' 123.001 ', signed), 123-------------where convert (value using CharSet), Converts the specified character set encoding As:select convert (' To value ' using UTF8)//to UTF8

　　

SQL time format conversion in MySQL