Skip to content

Instantly share code, notes, and snippets.

@maravilloso

maravilloso/Convertir Tipos.sql

Last active December 18, 2015 09:39
Show Gist options
  • Save maravilloso/5763300 to your computer and use it in GitHub Desktop.
Save maravilloso/5763300 to your computer and use it in GitHub Desktop.
Download ZIP
Conversiones entre tipos diferentes de datos
Raw
Convertir Tipos.sql
SELECT CAST(columna AS MONEY(8,2)) FROM tabla;
-- o con el operador ::
SELECT idprov, (idprov[3,4]+60)::INT::VARCHAR(5) AS subcod
FROM provincias
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment