Unanswered: how can I convert seconds from 1970-01-01 00:00:00 to datetime?
I have a int value represents the seconds from 1970-01-01 00:00:00，now I want to convert it to datetime format。
C++ can implements this function , 'print dateadd(ss, intvalue, '1970-01-01 00:00:00')' in sql server can resolve this problem also , but is there a simple method can do same thing in sybase sql ?
yes indeed, there is a simple function in sybase which can do this...
and it is...... dateadd too !
(once upon a time, sqlServer and Sybase were the same product...)