in TD we have -- CAST((CAST(FROM_TIME AS INTEGER) MOD 60) AS FORMAT '99') . How to achieve the same in Redshift?
thanks KN
KN
已提问 3 年前371 查看次数
In Amazon Redshift (RS), the equivalent SQL expression of the Teradata (TD) SQL you provided is as follows:
CAST((CAST(FROM_TIME AS INTEGER) % 60) AS VARCHAR(2))
Sedat SALMAN
已回答 3 年前
thankyou.. How about these ones?
,col1 (format '9(3).99') (CHAR(6)) 35.0 ---> 035.00
,col2 (format '9(5).99') (CHAR(8)) 12,931.10 ---> 12931.10 5,132.40 ---> 05132.40
,cast('3999-12-31' as date) (format 'yymmdd') (char(6)) o/p is 991231
您未登录。 登录 发布回答。
一个好的回答可以清楚地解答问题和提供建设性反馈，并能促进提问者的职业发展。
rePost Polyglot
已提问 3 年前
Max
已提问 1 年前
whb
已发布 2 年前
Tyler
已发布 1 年前
thankyou.. How about these ones?
,col1 (format '9(3).99') (CHAR(6)) 35.0 ---> 035.00
,col2 (format '9(5).99') (CHAR(8)) 12,931.10 ---> 12931.10 5,132.40 ---> 05132.40
,cast('3999-12-31' as date) (format 'yymmdd') (char(6))
o/p is 991231