: 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
- Original Message -
From: Jason Teagle [EMAIL
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
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
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
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
: 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 timestamp
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
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 Type
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
10 matches
Mail list logo