Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Timestamp wont Autoupdate

Status
Not open for further replies.
mhburney

mhburney

Programmer
Jul 26, 2005
23
PK
Hi,
Why is it that when i enter exactly the same data in the row the datestamp for that row wont get updated..otherwise the moment i change the data a bit the timestamp would get updated :(

Thanks in advance for any help

Cheers!
 
Sort by date Sort by votes
The record only gets physically updated if it needs to be. So, if no values have been changed, there is no need to update it. If you want to ensure that the value of a timestamp field gets updated, you need to assign it a new value:

UPDATE tbl
SET fld1='abc',fld2=456,timestampfield=NOW()
[/tt]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PCHomepage
  • Locked
  • Question
Pulling Our Pre-1970 Years from Unix Timestamp 1
2
Replies
32
Views
289
jpadie
jpadie
Albion
  • Locked
  • Question
Timestamp issues.
Replies
1
Views
67
Albion
Albion
mjoyner
  • Locked
  • Question
Need help converting a UTC string into a timestamp
Replies
0
Views
35
mjoyner
mjoyner
torvalen
  • Locked
  • Question
Timestamp formats
Replies
1
Views
32
r937
r937
HughbertD
  • Locked
  • Question
SQL statement for adding timeStamp columns
Replies
2
Views
54
HughbertD
HughbertD

Part and Inventory Search

Sponsor

Back
Top