Search code examples
sqldatepervasive-sql

Convert number to Date in Pervasive SQL

I am using Actian SQL Version 12.10.067 and trying to output some values.

When running the following query: 

SELECT Artikel, Deb, Datum,(BeginVoorraad + Mutatie)AS Stand 
from "Fust"
where Artikel IN (97955)
ORDER BY Artikel DESC

I get the output:

Artikel Deb    Datum   Stand
97955   200256 41865.0 68.0

Now I would like to change the Datum number(41865.0) to a real date like 22-08-2018.

I hope someone can help me with the right answer!

Solution

  • The correct Answer is 

    CAST((Datum -2) AS datetime)