sql server（常用）

//生成 uuid 并转为小写select LOWER(SUBSTRING(uuid,1,8)+’-’+SUBSTRING(uuid,10,4)+’-’+SUBSTRING(uuid,15,4)+’-’+SUBSTRING(uuid,20,4)+’-’+SUBSTRING(uuid,25,12)) from (select cast(NEWID() as varchar(36)) as uuid) s //ea52a7bb-a2aa-44b8-be28-5ebc64defcf9//获取时分秒select DateName(hour,GetDate())+ DateName(minute,GetDate())+DateName(second,GetDate()) //143054//1000-9999随机数select floor(9000*RAND()+1000)//日期格式化select GETDATE() //2019-02-12 14:30:16.763Select CONVERT(varchar(100), GETDATE(), 8) //10:57:46Select CONVERT(varchar(100), GETDATE(), 12) //060516Select CONVERT(varchar(100), GETDATE(), 20) //2006-05-16 10:57:47Select CONVERT(varchar(100), GETDATE(), 21) //2006-05-16 10:57:47.157 Select CONVERT(varchar(100), GETDATE(), 23) //2006-05-16Select CONVERT(varchar(100), GETDATE(), 24) //10:57:47Select CONVERT(varchar(100), GETDATE(), 25) //2006-05-16 10:57:47.250Select CONVERT(varchar(100), GETDATE(), 102)//2006.05.16Select CONVERT(varchar(100), GETDATE(), 111)//2006/05/16Select CONVERT(varchar(100), GETDATE(), 112)//20060516