Professional Web Applications Themes

MySQL datetime extraction - PHP Development

Given a date in MySQL datetime format, how do I extract the elements? That is get the month, day, year, hour, ... Thanks, Yasir...

Sponsored Links
  1. #1

    Default MySQL datetime extraction

    Given a date in MySQL datetime format, how do I extract the elements?
    That is get the month, day, year, hour, ...
    Thanks,
    Yasir
    Sponsored Links
    Yasir Malik Guest

  2. #2

    Default Re: [PHP] MySQL datetime extraction

    Thanks. Here's how I did it:
    $str = "2003-12-13 12:23:34"
    $b = localtime(strtotime($str), 1);
    printf("seconds: ".$a["tm_sec"]."\n");

    On Sat, 19 Jul 2003, John W. Holmes wrote:
    > Date: Sat, 19 Jul 2003 14:28:00 -0400
    > From: John W. Holmes <holmes072000charter.net>
    > To: Yasir Malik <ymalikcs.stevens-tech.edu>
    > Cc: [email]php-generallists.php.net[/email]
    > Subject: Re: [PHP] MySQL datetime extraction
    >
    > Yasir Malik wrote:
    > > Given a date in MySQL datetime format, how do I extract the elements?
    > > That is get the month, day, year, hour, ...
    >
    > You could do it in the query using DATE_FORMAT(), MONTH(), YEAR(), etc.
    >
    > You can do it in PHP by sending the MySQL timestamp through strtotime()
    > and then using date() to extract each component.
    >
    > --
    > ---John Holmes...
    >
    > Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
    >
    > PHP|Architect: A magazine for PHP Professionals – www.phparch.com
    >
    >
    >
    >
    Yasir Malik Guest

Similar Threads

  1. Java: MySQL DATETIME conversion errors?
    By Cédric Pillonel in forum MySQL
    Replies: 3
    Last Post: August 31st, 10:04 PM
  2. MySQL datetime record not updating with DW toolbox
    By planethead in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 2
    Last Post: August 13th, 07:05 PM
  3. Replies: 2
    Last Post: March 7th, 07:18 PM
  4. Translating MySQL timestamp to datetime
    By Joshua Beall in forum PHP Development
    Replies: 1
    Last Post: April 22nd, 02:50 PM
  5. [PHP] MySQL datetime extraction
    By David Nicholson in forum PHP Development
    Replies: 2
    Last Post: July 19th, 06:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139