MySQL Forums
Forum List  »  General

MYSQL TIMESTAMP - MIN DATE Config
Posted by: Kalaiselvan Rajendran
Date: May 01, 2020 12:11AM

Hi,

The MySQL TIMESTAMP is a temporal data type that holds the combination of date and time. The format of a TIMESTAMP is YYYY-MM-DD HH:MM:SS which is fixed at 19 characters. The TIMESTAMP value has a range from '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07'

Is that possible to configure minimum Datetime range to old. Like 1950's?
Our database using this datatype and recently we getting some new entries wil old date ranges.

Options: ReplyQuote


Subject
Written By
Posted
MYSQL TIMESTAMP - MIN DATE Config
May 01, 2020 12:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.