Home » RDBMS Server » Server Administration » conversion to Oracle
conversion to Oracle [message #374993] Tue, 17 July 2001 10:15
Federico Compte
Messages: 4
Registered: July 2001
Junior Member
Hi everyone!
I´m having some trouble converting the following from SQL Server into Oracle.
Can anyone help me?!

DATEADD(DAY,-1,(CONVERT(DATETIME,'01/'+'12'+'/'+ STR(SELECT 1900 FROM TABLE1 WHERE ID = '0'),103)))

Thanks in advance
Previous Topic: SQL*REPORT
Next Topic: ora-03106 fatal two task communication error
Goto Forum:
  


Current Time: Sun Jul 07 16:30:33 CDT 2024