e-
> From: Ricardas.S [mailto:[EMAIL PROTECTED]
> Sent: 21 March 2006 14:31
> To: [EMAIL PROTECTED]
> Subject: Re: Timestamp problem in mysql5.0.18
>
>
> Yes, I think you are right, it should be the main reason of
> insert failure.
> Thank you for good idea.
>
> Ricka
&
If you run the select "SELECT NOW() + 1*RAND();" a few times, you'll
see that not all values are valid timestamps, e.g.:
mysql> SELECT NOW() + 1*RAND();
+--+
| NOW() + 1*RAND() |
+--+
| 20050713112881 |
+--+
1 row in set
Hello.
There were several bugs related to timestamp
at 4.0.22 and later. Does the problem remains
on 4.1.12 (4.0.24)?
manasvini nandakumar <[EMAIL PROTECTED]> wrote:
> Hi all,
> I have a very strange problem with mysql-4.0.22
> running on a big endian processor platform.When the
> tim
p: RE: timestamp problem ..
The first timestamp in any table is automatically updated by mysql every
time you modify that record. It is the modify timestamp
If you wish to use the timestamp in your table, you should create two
timestamps at least and use the second one
Modstamp timestamp
Usable time
This is exactly what timestamp columns are supposed to do - see
http://www.mysql.com/doc/D/A/DATETIME.html
The first timestamp column in the table will be automatically updated
upon insert/update. Your choices are:
(1) Change to datetime type. Then, on insert, insert the current date
Wouter,
Friday, June 14, 2002, 4:53:20 PM, you wrote:
WvV> I'm having a slight problem with the timestamp column format. When I alter a
WvV> table and, add a column of type timestamp all records get the current
WvV> timestamp, that's ok. When i insert a new row, all records get the current
WvV> t
The first timestamp in any table is automatically updated by mysql every time you
modify that record. It is the modify timestamp
If you wish to use the timestamp in your table, you should create two timestamps at
least and use the second one
Modstamp timestamp
Usable timestamp
See here http:/
hehe, this got rejected because i didn't say
database or sql or query or table
:)
on 7/26/01 5:17 PM, Kory Wheatley at [EMAIL PROTECTED] wrote:
> is the TIMESTAMP option where I get the current date from.
try "now()" instead of "TIMESTAMP"
-- mike cullerton
-- mike cullerton
---
Omit the value for timestamp. mysql will do all by itself.
Kory Wheatley schrieb am Freitag, 27. Juli 2001, 01:17:22:
> I'm using PHP to add records into a mysql database. The records write
> successfully to the database
> except for the timestamp field which I have defined as
> Field T
Kory,
Since your fieldtype for "TheDate" is timestamp(14), you don't need a
function to insert a timestamp there.
In fact, what you're doing now is inserting the text "TIMESTAMP" into a date
field, which results in ''
Instead of 'TIMESTAMP', use NULL -- and don't put quotation marks a
10 matches
Mail list logo
