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 Functions

MySQL gives you a range of date and time related functions. In essence, the types of functions boil down to

  • Get current date and time

  • Format dates or times

  • Extract information (for example, name of a month of a given date)

  • Add and subtract date and time

  • Compare dates and times

It's worth noting that your data doesn't have to be in a MySQL table for you to use date functions! For example, if your programming language doesn't have some of the powerful functions that MySQL has—the capability to add and subtract dates, say—you can perform the query through MySQL just by using a SELECT statement on the data directly.

When passing a date or time to MySQL, it should be formatted slightly differently, depending on whether you are ...

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