title: Sybase equivalent in Oracle
body: <p>I am doing a change of code from Sybase to Oracle.
  I have problem in converting the below query to oracle.</p>
  
  <pre><code>Select Custodian_addr,convert(datetime,dateadd(ss,CreateDT,"01/01/1970")
  </code></pre>
  
  <p>Here <code>CreateDT</code> is the column name whose value for instance is <code>1015015173</code>
  The result for date conversion (for this example)is March 1 2002 8:39 PM GMT</p>
  
  <p>I researched and found an oracle alternative which results in error</p>
  
  <pre><code>Select Custodian_addr,to_char(CreateDT,"SS")
  </code></pre>
  
  <p>I am getting a query error in Oracle.I am not able to identify whats wrong. Since I am executing this in Perl [<code>"</code>] has to escaped or what might be the issue? Please suggest me a solution</p>