Professional Web Applications Themes

question about datetime column in mysql - MySQL

Hey there, i tried this question in the mysql group, but have not heard anything. i have a database with about 20 tables. The some of these tables have datetime type columns in them. What i am basically wondering is if there is a way to make a default value of now() apply if it is not specified when the row is created. i know this is possible with a timestamp, but is it possible with a datetime column ? and if so, how ?...

  1. #1

    Default question about datetime column in mysql

    Hey there,
    i tried this question in the mysql group, but have not heard anything.
    i have a database with about 20 tables. The some of these tables have
    datetime type columns in them. What i am basically wondering is if
    there is a way to make a default value of now() apply if it is not
    specified when the row is created.
    i know this is possible with a timestamp, but is it possible with a
    datetime column ? and if so, how ?

    nephish Guest

  2. #2

    Default Re: question about datetime column in mysql


    nephish wrote: 

    High. I think CURRENT_TIMESTAMP is meant to work, however you'd
    probably need to change your column to timestamp instead of date.

    Daz Guest

  3. #3

    Default Re: question about datetime column in mysql


    Daz wrote: 
    >
    > High. I think CURRENT_TIMESTAMP is meant to work, however you'd
    > probably need to change your column to timestamp instead of date.[/ref]

    thanks, i will check it out. I had actually considered using a time
    stamp, but did not know enough about it when i started to build.

    thanks again

    sk

    nephish Guest

Similar Threads

  1. Replies: 2
    Last Post: March 7th, 07:18 PM
  2. Translating MySQL timestamp to datetime
    By Joshua Beall in forum PHP Development
    Replies: 1
    Last Post: April 22nd, 02:50 PM
  3. Replies: 1
    Last Post: August 6th, 04:07 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