Bom dia,
Creio que o to_date ou to_timestamp consigam fazer o que essa function faz. Sem saber o que vc quer fazer de fato e em que versão do Oracle vai fazer, se bem que acho que o to_timestamp existe desde o 9i ou do 8i. --- Atenciosamente, Rodrigo Mufalani Database Consultant +55 XX(21) 3193-0326 [email protected] www.mufalani.com.br "Stop guessing… Be Sure… Because performance matters" Em 23/01/2014 11:55, Julio Romano escreveu: > Senhores, > > Alguém conhece alguma correspondência no Oracle para a função FROM_UNIXTIME > do MySQL? > Exemplo de instrução no MYSQL que utiliza desta função: > > update SLA_Reports_resposta > set TEMPO_RESPOSTA_FEITO = CURRENT_TIMESTAMP, > TEMPO_RESPOSTA_FEITO_LIMITE=FROM_UNIXTIME(NEW.escalation_response_time) > where tn = NEW.tn ; > > Att, > Julio Romano. > Links: ------ [1] http://br.groups.yahoo.com/group/oracle_br/post;_ylc=X3oDMTJycDlwODNoBF9TAzk3NDkwNDM3BGdycElkAzE2ODI4OTYEZ3Jwc3BJZAMyMTM3MTE0Njg5BG1zZ0lkAzExNTc4NQRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzOTA0ODUzMjY-?act=reply&messageNum=115785 [2] http://br.groups.yahoo.com/group/oracle_br/post;_ylc=X3oDMTJlbTZhc210BF9TAzk3NDkwNDM3BGdycElkAzE2ODI4OTYEZ3Jwc3BJZAMyMTM3MTE0Njg5BHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTM5MDQ4NTMyNg-- [3] http://br.groups.yahoo.com/group/oracle_br/message/115785;_ylc=X3oDMTM4M2RobmxmBF9TAzk3NDkwNDM3BGdycElkAzE2ODI4OTYEZ3Jwc3BJZAMyMTM3MTE0Njg5BG1zZ0lkAzExNTc4NQRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzOTA0ODUzMjYEdHBjSWQDMTE1Nzg1 [4] http://br.groups.yahoo.com/group/oracle_br/members;_ylc=X3oDMTJmcDR2cHRiBF9TAzk3NDkwNDM3BGdycElkAzE2ODI4OTYEZ3Jwc3BJZAMyMTM3MTE0Njg5BHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzEzOTA0ODUzMjY-?o=6 [5] http://br.groups.yahoo.com/group/oracle_br;_ylc=X3oDMTJlcmJmMnBhBF9TAzk3NDkwNDM3BGdycElkAzE2ODI4OTYEZ3Jwc3BJZAMyMTM3MTE0Njg5BHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTM5MDQ4NTMyNg-- [6] http://www.mail-archive.com/[email protected]/ [7] https://br.groups.yahoo.com/neo/groups/oracle_br/conversations/messages [8] http://br.groups.yahoo.com/;_ylc=X3oDMTJkZDdiYjBiBF9TAzk3NDkwNDM1BGdycElkAzE2ODI4OTYEZ3Jwc3BJZAMyMTM3MTE0Njg5BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzkwNDg1MzI2 [9] http://info.yahoo.com/legal/br/yahoo/utos/terms/
