Skip to Main Content
Sams Teach Yourself MySQL in 21 Days, Second Edition
book

Sams Teach Yourself MySQL in 21 Days, Second Edition

by Tony Butcher
December 2002
Beginner content levelBeginner
640 pages
16h 41m
English
Sams
Content preview from Sams Teach Yourself MySQL in 21 Days, Second Edition

Date and Time

MySQL has a range of data types for handling date and time information. Time formats have an intuitive order that you're used to in daily life: hours:minutes:seconds. Dates, on the other hand, are always output in the format: year:month:day. Both conform to ANSI-92 standard format.

All date and time data types have a range of legal values and a “zero” value to which a field will be set if you attempt to put an illegal value into it.

When outputting date and time, you usually have the option to ask MySQL to give you the data in either string or numeric form. The format depends on the context in which it's used in your SQL.

MySQL is flexible when accepting date and time information. For example, the date 2003-05-12 means the same ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Sams Teach Yourself MySQL

Sams Teach Yourself MySQL

Chris Newman
Oracle® Database 10g Insider Solutions

Oracle® Database 10g Insider Solutions

Arun Kumar R., John Kanagaraj, Richard Stroupe
MySQL and mSQL

MySQL and mSQL

Tim King, George Reese, Randy Yarger
Jump Start MySQL

Jump Start MySQL

Timothy Boronczyk

Publisher Resources

ISBN: 0672323923Purchase book