Pessoal, Estou precisando de uma ajuda no sql abaixo: Quero pegar somente a parte inteira da subtração de duas data.
select dt_abertura,dt_fim,(dt_fim - dt_abertura)no_dias from osservhe; dt_abertura | dt_fim | no_dias -------------+-------------------------+------------------------ 2012-11-18 | 2012-11-18 23:09:09 | 23:09:09 2012-07-23 | 2012-09-18 22:21:10 | 57 days 22:21:10 2012-09-10 | 2012-09-18 22:43:56 | 8 days 22:43:56 2012-09-03 | 2012-09-18 23:44:33 | 15 days 23:44:33 2012-08-05 | 2012-09-21 23:39:09 | 47 days 23:39:09 2012-08-15 | 2012-09-21 23:46:41 | 37 days 23:46:41 2012-08-12 | 2012-09-21 23:49:15 | 40 days 23:49:15 2012-08-06 | 2012-09-22 00:01:15 | 47 days 00:01:15 2012-08-05 | 2012-09-22 00:10:55 | 48 days 00:10:55 2012-07-23 | 2012-09-22 00:16:55 | 61 days 00:16:55 2012-10-26 | 2012-10-26 22:26:29 | 22:26:29 2012-09-10 | 2012-09-18 22:30:58 | 8 days 22:30:58 2012-07-22 | 2012-09-18 22:11:40 | 58 days 22:11:40 -- Edson _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
