MySQL Date and Time Types

MySQL Date and Time Types. Page 1. DATETIME. DATE. TIMESTAMP. TIME. YEAR. “Zero” value. '0000-00-00 00:00:00'. '0000-00-00'. '0000-00-00 00:00:00'.
43KB taille 0 téléchargements 296 vues
MySQL Date and Time Types

“Zero” value Storage requirement (Bytes) Date information Time information Display format Display width (Characters) MAXDB SQL mode enabled

DATETIME '0000-00-00 00:00:00'

DATE '0000-00-00'

TIMESTAMP '0000-00-00 00:00:00'

8 Yes Yes 'YYYY-MM-DD HH:MM:SS' 19 -

3 Yes No 'YYYY-MM-DD'

TIME '00:00:00' 4

YEAR 0000 3

1

No Yes 'HH:MM:SS'

Yes No YYYY

-

Yes Yes 'YYYY-MM-DD HH:MM:SS' 19 DATETIME

-

-

'1000-01-01' '9999-12-31'

1970 2037

'-838:59:59' '838:59:59'

1901 2155

Yes Yes

No No

No No

Range of legal values Min Max

'1000-01-01 00:00:00' '9999-12-31 23:59:59'

Automatic ? to the current date and time Initialization Updating

No No

No No

Page 1