• Inviting everyone who uses WordPress management tools in Plesk
    The Plesk team is conducting a 60-minute research session that includes an interview and a moderated usability test.
    To participate, please use this link .
    Your experience will help shape product decisions and ensure the tools better support real-world use cases.

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