
¿Que siginifica esta linea de codigo?
Publicado por manolo (2 intervenciones) el 11/08/2014 02:32:54
Buenas, alguien podria explicarme que hace esta linea de codigo, e leido acerca de estas palabras reservadas pero no termino de enteder su funcionamiento en todo la linea. Lenguaje SQL
round((((cxc.montocapital * cre.credinteres)/100)) * CAST((CASE WHEN (EXTRACT(DAY FROM (AGE(CAST(cre.credfchsolicitud AS DATE))))) >= 30 THEN 30 ELSE (EXTRACT(DAY FROM (AGE(CAST(cre.credfchsolicitud AS DATE))))) END) + (EXTRACT(MONTH FROM (AGE(CAST(cre.credfchsolicitud AS DATE))))) * 30 + (EXTRACT(YEAR FROM (AGE(CAST(cre.credfchsolicitud AS DATE))))) * 360 AS NUMERIC)
/ 360 ,2) as interesctaalafecha
round((((cxc.montocapital * cre.credinteres)/100)) * CAST((CASE WHEN (EXTRACT(DAY FROM (AGE(CAST(cre.credfchsolicitud AS DATE))))) >= 30 THEN 30 ELSE (EXTRACT(DAY FROM (AGE(CAST(cre.credfchsolicitud AS DATE))))) END) + (EXTRACT(MONTH FROM (AGE(CAST(cre.credfchsolicitud AS DATE))))) * 30 + (EXTRACT(YEAR FROM (AGE(CAST(cre.credfchsolicitud AS DATE))))) * 360 AS NUMERIC)
/ 360 ,2) as interesctaalafecha
Valora esta pregunta


0