Redshift: Convert TEXT to Timestamp

Posted Leave a commentPosted in AWS, Redshift

How do you convert TEXT to timestamp in redshift? If the score column has data in given format, how can you display the timestamp. {“Choices”:null, “timestamp”:”1579650266955″, “scaledScore”:null} select cast(json_extract_path_text(score, ‘timestamp’) as timestamp) from schema.table limit 10; This sql will fail with — ERROR: Invalid data DETAIL: ———————————————– error: Invalid data code: 8001 context: Invalid format […]