常用時間功能
一、mysql基本時間格式之間的轉(zhuǎn)換
SELECT DATE_FORMAT(now(),'%Y-%m-%d') as? sdtime1 ,
DATE_FORMAT(now(),'%Y-%m-%d %H:%m:%s') as? sdtime2
,UNIX_TIMESTAMP(now())? unixtime ,
FROM_UNIXTIME(UNIX_TIMESTAMP(now()),'%Y-%m-%d' ) timetcg,
DATEDIFF(now(),'2017-03-25') as days ,
DATE_ADD(now(),INTERVAL 8 day) as? addday ,
DATE_ADD(now(),INTERVAL 8 month) as? addday,
DATE_sub(now(),INTERVAL 8 day) as? subday
二、sqlserver基本時間格式的轉(zhuǎn)化
select ? CONVERT(data_type(length),data_to_be_converted,style) ?
select ? ?CONVERT(VARCHAR(10),GETDATE(),120)? >>>2017-07-31 ?最常用的格式 ?
SELECT? CONVERT(FLOAT ,'12.58') +10 ? >>> 22.58
SELECT? cast('2014-10-11' as char(10))? >>>2014-10-11 ?# 把數(shù)字轉(zhuǎn)化成文本
----------------------------------------------------
