SQL Server Forums - Convert Decimal to DateTime
DOn't know anything about Pervasive but there is a form of CONVERT called CAST, perhaps you can check the Pervasive manual? SELECT CAST(CAST(ord_dt as VARCHAR(8)) as datetime) FROM OEORDHDR_SQL Maybe Pervasive has a Date datatype, rather ......