Inputting year 999

nyy · #1 (**permalink**) 10-04-04, 07:48

I am using timestamp as date in database.

By MySQL manual, date type range is 1000-01-01 to 9999-12-31.
Is there any way to input year 999 or do I have to use int or chars manually?

Anyone have better idea of using year 999 or before that?

guelphdad · #2 (**permalink**) 10-04-04, 08:34

Do you actually need to use 999 or are you using it for a default value? If default use NULL instead.

If 999 is actually needed you probably need to use type of CHAR for your column though you wouldn't be able to do date calculations that you can with a DATE column type.

nyy · #3 (**permalink**) 10-05-04, 04:05

I need to use year before 999. I was thinking I have to use CHAR for my column.
But it seems I can insert data that is less than year 1000. I will see if this actually works.

Thanks.

RBARAER · #4 (**permalink**) 10-05-04, 06:02

Hello,

From the SQL manual :

Quote:

The DATETIME type is used when you need values that contain both date and time information. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM

S' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. (``Supported'' means that although earlier values might work, there is no guarantee that they will.)

So you can try it at your own risk !

Regards,

RBARAER

Internet Services

Web Development

Digital Marketing

Consumer Tech