Professional Web Applications Themes

datetime in mysql - PHP Development

Hi i am inserting various values in a mysql table via php. now the ID is auto increment but how do i get the datetime to update when i post the values to say the new ID (row) that my "INSERT INTO / VALUES sql statement has just preformed? i can format a string for the datetime and send that with the insert but just wondering if there is a shortcut. Mark...

  1. #1

    Default datetime in mysql

    Hi

    i am inserting various values in a mysql table via php. now the ID is auto
    increment but how do i get the datetime to update when i post the values to
    say the new ID (row) that my "INSERT INTO / VALUES sql statement has just
    preformed?

    i can format a string for the datetime and send that with the insert but
    just wondering if there is a shortcut.

    Mark

    Mark Guest

  2. #2

    Default Re: datetime in mysql

    Mark D Smith wrote:
     

    erm...

    INSERT INTO myTable (dateField) VALUES (now());

    Go get a copy of the MySQL manual - there's a whole load of functions for
    working with dates/times in MySQL

    C.
    Colin Guest

  3. #3

    Default Re: datetime in mysql

    "Colin McKinnon" <mms3.com> wrote in message
    news:d9ravh$jaa$1$demon.co.uk... [/ref]
    auto 
    >
    > erm...
    >
    > INSERT INTO myTable (dateField) VALUES (now());
    >
    > Go get a copy of the MySQL manual - there's a whole load of functions for
    > working with dates/times in MySQL
    >
    > C.[/ref]

    works like a dream, note comment on manual will get round to it.

    thanks

    Mark

    Mark Guest

Similar Threads

  1. question about datetime column in mysql
    By nephish in forum MySQL
    Replies: 2
    Last Post: October 30th, 01:41 PM
  2. PHP, MySQL and datetime
    By Joe in forum PHP Development
    Replies: 5
    Last Post: May 24th, 06:51 PM
  3. Translating MySQL timestamp to datetime
    By Joshua Beall in forum PHP Development
    Replies: 1
    Last Post: April 22nd, 02:50 PM
  4. MySQL datetime extraction
    By Yasir Malik in forum PHP Development
    Replies: 1
    Last Post: July 19th, 07:27 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