Need to change an expirydate in subscriptionlog table

[Snowhog]

The circled expirydate is incorrect. This happened because the Paid Subscription for this level (8) was set to expire in 28 years when it was established. I didn't catch that, and a Paid Subscription at that level was purchased on May 30, 2025. For the user, it was set to expire on Sat Jan 02 2038 00:00:00 GMT+0000!

I've corrected the expiration date via the Paid Subscription Manager, but now I need to fix the established record.

The expirydate should be: 1780181535 (Sat May 30 2026 22:52:15 GMT+0000)

Is this the correct mySQL query to accomplish this?

UPDATE subscriptionlog
SET expirydate = REPLACE(expirydate, '2146003200', '1780181535')
WHERE subscriptionlogid = '88';

[Snowhog]

Never mind! Just realized I can edit the Paid Subscription in AdminCP > User Manager. Doh!

[Snowhog]

I would still like confirmation that the mySQL query I indicated is correct, and would have made the change too.