• We value your experience with Plesk during 2025
    Plesk strives to perform even better in 2026. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2025.
    Please take this short survey:

    https://survey.webpros.com/

PSA Database question (Date Format)

R

rholzler

Guest
See the following MySQL DB
Database: PSA
Table: Limits

There there are two fields "value" and "expiration" which are related to domain hosting expiration dates. The "value" looks like this:

1221624000

I am trying to create a custom report, and I need to know what format this data is using. At first I thought it was a Julian date, but it is too many digits. Is this a measure of minutes, seconds or what?

How do I convert this into a piece of meaningful data?

Additional Info: What I am trying to do is create a hosting report that shows domains that are coming up on their hosting renewal dates so I can bill them based on their hosting plan.
 
rholzler

This data format considers the value of seconds left till 1 January 1970. So, I believe you can proceed with custom report basing on this info.
 
Back
Top