Firebird datetime format
I have VTS function that transform the data into datetime.
My aim is to select datetime with this specific format (MM-DD-YYYY HH:mm).
The initial data in TIME column (Int64):
131473080013710000
131473080026060000
131473080039030000
Transform with VTS(string) function (select VTS("TIME"))
20170816000001.3710000
20170816000002.6060000
20170816000003.9030000
Needed result (YYYY-MM-DD HH:mm):
2017-08-16 00:00
2017-08-16 00:00
2017-08-16 00:00
I tried with: select VTS("TIME", 'YYYY-MM-DD HH:mm').
ErrorMessage: function VTS could not be matched