cloudflare / cloudflare/cfssl

timestamp column not compatible with 2038+ dates

Open
#1,329 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
9.5k
Forks
1.2k
PR merge metrics
No merged PRs in 30d

Description

CFSSL [is using](https://github.com/cloudflare/cfssl/blob/e95f50ec0ee3de982a6353393adfc167942ef62e/certdb/mysql/migrations/001_CreateCertificates.sql#L10) `timestamp` for storing timestamps in MySQL/MariaDB. [Currently it is not compatible](https://mariadb.com/kb/en/timestamp/) with dates over 2038.

Consider migration timestamp columns to safer type, i.e. `datetime` holding UTC times to allow users to save certs that will need to be valid in 2038+ period.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.