1 Answer
- Newest
- Most votes
- Most comments
2
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))
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
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