jbecker614
Technical User
I work with an application that uses a date format of the number of days passed since 01/01/0001.
Would any one know of the correct function to use to convert into a date through PSQL. I can do the conversion usind DateSerial after linked to MS SQL or MS Excel, but I was curious to see what the equivalent would be when creating a PSQL view from the Pervasive Control Center.
For Example, our application would store 732342. If I export into excel, I can subtract 693594 from it to get a value of 38748. This value represents the number of days since 01/01/1901. When formatted as a date in Excel it would then show correctly as 01/31/2006.
Would any one know of the correct function to use to convert into a date through PSQL. I can do the conversion usind DateSerial after linked to MS SQL or MS Excel, but I was curious to see what the equivalent would be when creating a PSQL view from the Pervasive Control Center.
For Example, our application would store 732342. If I export into excel, I can subtract 693594 from it to get a value of 38748. This value represents the number of days since 01/01/1901. When formatted as a date in Excel it would then show correctly as 01/31/2006.