i have sybase database , create new bigdatetimefield adding time current bigdatetimefield
for example
i have date1 field = 8/31/2015 2:23:49.529000 pm have date2 field = 8/31/2015 7:23:49.529000 have maindate field = 8/31/2015 2:24:46.112000 pm
i make new field maindate field minus difference in time between date1 field , date2 field
so in case new filed 8/31/2015 2:24:46.112000 pm - (8/31/2015 2:23:49.529000 pm - 8/31/2015 7:23:49.529000 am)
any idea how in sybase?
select new_dt = dateadd(ss, datediff(ss,date1,date2),maindate) my_table
that's accurate seconds though. can use millisecond or microsecond.
Comments
Post a Comment