I'm not aware of a Qlik function which could do this, but there might be a math behind, see here:
Anyway, are you able to retrieve data from SQL and store it as string into QVDs while you have the DB available? If you store it in QVDs in correct format now, no need to worry about conversions in future.
Hope this helps
Thanks for the reply, I will definitely look into the math conversion. As for storing the the data into qvds and reusing it, that unfortunately won't work as the data can get updated by users in the application which generates the data stored in the SQL database. So I need to update the data in Qlik as it gets updated in the SQL DB.
I will look into your link and see if I can get a function to convert it. I will reply on your post if I can get it to work.