I am using Ingres Db which is old and cant do much,
I need to show datetime in specific format as 

> 
> dd-mm-yyyy hh:mm:ss
> 
> 
> 

DB retunrn me it as 

> 
> 01.02.2018 14:43:53
> 
> 
> 

it is **NOT SQL server** so I CANNOT use CONVERT(VARCHAR(10)
Is there a way to convert it to format i need ?