将 1526918600 转为 2018-05-22 00:03:20 的sql语句:
select rtrim(STR_REPLACE(CONVERT(char, dateadd(ss, 1526918600,'1970/01/01 08:00'), 111) ,'/','-')
+' '+CONVERT(varchar, dateadd(ss, 1526918600,'1970/01/01 08:00'), 108))
函数CONVERT()的详解见:https://blog.csdn.net/source0/article/details/2561819
update o set o.recoverytime =
rtrim(STR_REPLACE(CONVERT(char, dateadd(ss, e.createtime,'1970/01/01 08:00'), 111) ,'/','-')
+' '+ CONVERT(varchar, dateadd(ss, e.createtime,'1970/01/01 08:00'), 108))
from e
where o.ip=e.ip and e.id=12345
o表和e表用ip关联,更新o表的recoverytime字段为e表的createtime字段
==============================我是分割线=======================================
其他sybase的奇技淫巧待补充