Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2019
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.77 KB | None | 0 0
  1. SELECT
  2.   pat_vis_ri_reporte.bi_rotulo,
  3.   pat_vis_ri_reporte.bi_desc,
  4.   pat_vis_ri_reporte.bi_fecadquisicion,
  5.   pat_vis_ri_reporte.mov_seccion,
  6.   pat_vis_ri_reporte.analitico1_desc,
  7.   pat_vis_ri_reporte.analitico2_desc,
  8.   pat_vis_ri_reporte.cta_desc,
  9.   pat_vis_ri_reporte.cta_ppal_desc,
  10.   pat_bienes.bi_vida_util,
  11.   pat_bienes.bi_id,
  12.   date_trunc ('YEAR', pat_bienes.bi_fecadquisicion) +  CAST('364 days' AS INTERVAL) AS Fechainidespre,
  13.   date_trunc ('YEAR',pat_bienes.bi_fecadquisicion +  (CAST('364 days' AS INTERVAL)* pat_bienes.bi_vida_util))  +  CAST('364 days' AS INTERVAL) AS FechafINDES
  14. FROM
  15.   public.pat_vis_ri_reporte,
  16.   public.pat_bienes
  17. WHERE
  18.   pat_bienes.bi_rotulo = pat_vis_ri_reporte.bi_rotulo AND
  19.   pat_vis_ri_reporte.bi_rotulo = '2012';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement