Skip to content

Instantly share code, notes, and snippets.

@tecmaverick

tecmaverick/Redshift Datatype Conversion.sql

Last active March 6, 2022 11:48
Show Gist options
  • Save tecmaverick/385c8c7c4b170276a774bf21d9abb645 to your computer and use it in GitHub Desktop.
Save tecmaverick/385c8c7c4b170276a774bf21d9abb645 to your computer and use it in GitHub Desktop.
Download ZIP
Redshift Datatype Conversion
Raw
Redshift Datatype Conversion.sql
SELECT integer '1' id;
SELECT timestamp '2010-10-31 01:00:00' test_datetime;
-- Concat integer to text. Outputs 12
SELECT 1::text || 2::text concat_demo
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment