How to determine the version of Redshift database

Run the below query to determine the version of Redshift as well as the operating system of the underlying host.

select version();

See also  LEFT and RIGHT functions in Redshift database