1 Resposta
- Mais recentes
- Mais votos
- Mais comentários
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))
Conteúdo relevante
- AWS OFICIALAtualizada há um ano
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