Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- string(19) "2012-10-21 04:29:59"
- SELECT t0.co_historial_anexo, to_char(t0.fe_descargado+('-04:30'::interval), 'YYYY-MM-DD HH24:MI:00') as fe_descargado, to_char(t0.fe_descargado+('-04:30'::interval), 'HH12:MI:SS am') as hora_sucursal_12, to_char(t0.fe_descargado+('-04:30'::interval), 'HH24:MI:SS') as hora_sucursal_24, to_char(t0.fe_descargado+('-04:30'::interval), 'DD/MM/YYYY') as fecha_sucursal, to_char(t0.fe_descargado+('-04:30'::interval), 'YYYY,MM,DD') as fecha_datepicker, to_char(t0.fe_descargado+('-04:30'::interval),'DD/MM/YYYY - HH12:MI:SS am') as hora_administrador_12, to_char(t0.fe_descargado+('-04:30'::interval),'DD/MM/YYYY - HH24:MI:SS') as hora_administrador_24,t0.bo_leido,t0.bo_efectivo, (CASE WHEN t0.bo_efectivo=false THEN 'SesionTP' ELSE 'SesionOtorgadoE' END) as metodo_pago, t0.bo_comprado, t0.nu_precio, t0.co_usuario, t2.nb_anexo FROM framework.j014_z004vl_historial_anexo t0, framework.j013t_anexo t2 WHERE t0.co_anexo = t2.co_anexo AND t0.co_sala_sucursal_presencial = 1 AND t0.fe_descargado BETWEEN '2012-10-20 04:30:00' AND '2012-10-21 04:29:59'
- SELECT t0.co_historial_anexo, to_char(t0.fe_descargado+('-04:30'::interval), 'YYYY-MM-DD HH24:MI:00') as fe_descargado, to_char(t0.fe_descargado+('-04:30'::interval), 'HH12:MI:SS am') as hora_sucursal_12, to_char(t0.fe_descargado+('-04:30'::interval), 'HH24:MI:SS') as hora_sucursal_24, to_char(t0.fe_descargado+('-04:30'::interval), 'DD/MM/YYYY') as fecha_sucursal, to_char(t0.fe_descargado+('-04:30'::interval), 'YYYY,MM,DD') as fecha_datepicker, to_char(t0.fe_descargado+('-04:30'::interval),'DD/MM/YYYY - HH12:MI:SS am') as hora_administrador_12, to_char(t0.fe_descargado+('-04:30'::interval),'DD/MM/YYYY - HH24:MI:SS') as hora_administrador_24,t0.bo_leido,t0.bo_efectivo, (CASE WHEN t0.bo_efectivo=false THEN 'SesionTP' ELSE 'SesionOtorgadoE' END) as metodo_pago, t0.bo_comprado, t0.nu_precio, t0.co_usuario, t2.nb_anexo FROM framework.j014_z004vl_historial_anexo t0, framework.j013t_anexo t2 WHERE t0.co_anexo = t2.co_anexo AND t0.co_sala_sucursal_presencial = 2 AND t0.fe_descargado BETWEEN '2012-10-20 04:30:00' AND '2012-10-21 04:29:59'
- SELECT t0.co_historial_anexo, to_char(t0.fe_descargado+('-04:30'::interval), 'YYYY-MM-DD HH24:MI:00') as fe_descargado, to_char(t0.fe_descargado+('-04:30'::interval), 'HH12:MI:SS am') as hora_sucursal_12, to_char(t0.fe_descargado+('-04:30'::interval), 'HH24:MI:SS') as hora_sucursal_24, to_char(t0.fe_descargado+('-04:30'::interval), 'DD/MM/YYYY') as fecha_sucursal, to_char(t0.fe_descargado+('-04:30'::interval), 'YYYY,MM,DD') as fecha_datepicker, to_char(t0.fe_descargado+('-04:30'::interval),'DD/MM/YYYY - HH12:MI:SS am') as hora_administrador_12, to_char(t0.fe_descargado+('-04:30'::interval),'DD/MM/YYYY - HH24:MI:SS') as hora_administrador_24,t0.bo_leido,t0.bo_efectivo, (CASE WHEN t0.bo_efectivo=false THEN 'SesionTP' ELSE 'SesionOtorgadoE' END) as metodo_pago, t0.bo_comprado, t0.nu_precio, t0.co_usuario, t2.nb_anexo FROM framework.j014_z004vl_historial_anexo t0, framework.j013t_anexo t2 WHERE t0.co_anexo = t2.co_anexo AND t0.co_sala_sucursal_presencial = 3 AND t0.fe_descargado BETWEEN '2012-10-20 04:30:00' AND '2012-10-21 04:29:59'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
