timestampdiff(ss,xxxx, NOW() ) > 0
↓
timestampdiff(SECOND,xxxx, NOW() ) > 0
CHAR_LENGTH(RTRIM(CONVERT(integer, RIGHT(MAX(xxx), 9)) + 1))
↓
CHAR_LENGTH(RTRIM(CAST(RIGHT(MAX(xxx), 9) as SIGNED) + 1))
CONVERT(CHAR(1), CONVERT(integer, RIGHT(MAX(xxx), 9)) + 1)
↓
cast((cast(RIGHT(MAX(xxx), 9) as SIGNED) + 1) as char(1))
LEN(LTRIM(RTRIM(xxx)))
↓
CHAR_LENGTH(TRIM(xxx))
お金
REPLACE(CONVERT(VARCHAR,CONVERT(MONEY,BidInfo.xxx),1), '.00','')
↓
REPLACE(cast(cast(BidInfo.xxx as DECIMAL(15,4)) as char) , '.00','')
select DATE_FORMAT(NOW() - NOW(),'%d')-1
年
DATE_FORMAT(S.RakuRGPZ ,'%Y')
月
DATE_FORMAT(S.RakuRGPZ ,'%m')
日
DATE_FORMAT(DispInfo.xxx - NOW() ,'%d')-1
時
DATE_FORMAT(DispInfo.xxx - NOW() ,'%H')
分
DATE_FORMAT(DispInfo.xxx - NOW() ,'%i')
秒
DATE_FORMAT(DispInfo.xxx - NOW() ,'%s')
LEN(CONVERT(INTEGER, MAX(LEFT(xxx, 2)) + 1))
↓
CHAR_LENGTH(cast(MAX(LEFT(xxx, 2)) as SIGNED) + 1)
CONVERT(CHAR(1), CONVERT(INTEGER, MAX(LEFT(xxx, 2)) + 1))
↓
cast(cast(max(left(xxx, 2)) + 1 as SIGNED) as char(1))
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme
List of users who liked
11