Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


    Copyright
    Preface
    Ch. 1. Using the mysql Client Program
    Ch. 2. Writing MySQL-Based Programs
    Ch. 3. Record Selection Techniques
    Ch. 4. Working with Strings
    Ch. 5. Working with Dates and Times
    Introduction
    Changing MySQL's Date Format
    Telling MySQL How to Display Dates or Times
    Determining the Current Date or Time
    Decomposing Dates and Times Using Formatting Functions
    Decomposing Dates or Times Using Component-Extraction Functions
    Decomposing Dates or Times Using String Functions
    Synthesizing Dates or Times Using Formatting Functions
    Synthesizing Dates or Times Using Component-Extraction Functions
    Combining a Date and a Time into a Date-and-Time Value
    Converting Between Times and Seconds
    Converting Between Dates and Days
    Converting Between Date-and-Time Values and Seconds
    Adding a Temporal Interval to a Time
    Calculating Intervals Between Times
    Breaking Down Time Intervals into Components
    Adding a Temporal Interval to a Date
    Calculating Intervals Between Dates
    Canonizing Not-Quite-ISO Date Strings
    Calculating Ages
    Shifting Dates by a Known Amount
    Finding First and Last Days of Months
    Finding the Length of a Month
    Calculating One Date from Another by Substring Replacement
    Finding the Day of the Week for a Date
    Finding Dates for Days of the Current Week
    Finding Dates for Weekdays of Other Weeks
    Performing Leap Year Calculations
    Treating Dates or Times as Numbers
    Forcing MySQL to Treat Strings as Temporal Values
    Selecting Records Based on Their Temporal Characteristics
    Using TIMESTAMP Values
    Recording a Row's Last Modification Time
    Recording a Row's Creation Time
    Performing Calculations with TIMESTAMP Values
    Displaying TIMESTAMP Values in Readable Form
    Ch. 6. Sorting Query Results
    Ch. 7. Generating Summaries
    Ch. 8. Modifying Tables with ALTER TABLE
    Ch. 9. Obtaining and Using Metadata
    Ch. 10. Importing and Exporting Data
    Ch. 11. Generating and Using Sequences
    Ch. 12. Using Multiple Tables
    Ch. 13. Statistical Techniques
    Ch. 14. Handling Duplicates
    Ch. 15. Performing Transactions
    Ch. 16. Introduction to MySQL on the Web
    Ch. 17. Incorporating Query Resultsinto Web Pages
    Ch. 18. Processing Web Input with MySQL
    Ch. 19. Using MySQL-Based Web Session Management
    Appx. A. Obtaining MySQL Software
    Appx. B. JSP and Tomcat Primer
    Appx. C. References
    Colophon
    Index
    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • DownloadDownload
    • PrintPrint
    Share this Page URL
    Help

    Chapter 5. Working with Dates and Times > Displaying TIMESTAMP Values in Readab...

    5.36. Displaying TIMESTAMP Values in Readable Form

    5.36.1. Problem

    You don't like the way that MySQL displays TIMESTAMP values.

    5.36.2. Solution

    Reformat them with the DATE_FORMAT( ) function.


      

    You are currently reading a PREVIEW of this book.

                                                                                            

    Get instant access to over
    $1 million worth of books and videos.

      

    Start a Free Trial