[Solved] how to find seconds left in a day,in sql?

In MS SQL this might be one of the ways

select 86400 - (DATEPART(second, CURRENT_TIMESTAMP) + 60 * DATEPART(minute, CURRENT_TIMESTAMP) + 3600 * DATEPART(hour, CURRENT_TIMESTAMP))