Citação de
Kindrazki em 23 de dezembro de 2016, 08:54
Postgres: Calculo de Tempo entre 2 campos String
[code]
select to_char(to_timestamp(h2, 'yyyy-mm-dd hh24:mi:ss') - to_timestamp(h1, 'yyyy-mm-dd hh24:mi:ss'), 'yyyy-dd-dd hh24:mi:ss') as dif
from (
select cast('2000-01-01 08:22:07' as varchar(128)) as h1, cast('2000-01-01 11:10:12' as varchar(128)) as h2
) x
[/code]
Postgres: Calculo de Tempo entre 2 campos String
[code]
select to_char(to_timestamp(h2, 'yyyy-mm-dd hh24:mi:ss') - to_timestamp(h1, 'yyyy-mm-dd hh24:mi:ss'), 'yyyy-dd-dd hh24:mi:ss') as dif
from (
select cast('2000-01-01 08:22:07' as varchar(128)) as h1, cast('2000-01-01 11:10:12' as varchar(128)) as h2
) x
[/code]
