473,224 Members | 1,473 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

timstamp

Ike
I havea timestamp field in a table which shows the timestamp of the last
update or insert to a given row. Is there a way to temporarily turn that
off, such that I can update a row withOUT affecting timestamp? Thanks, Ike
Jun 4 '06 #1
1 1559
Not that I know of, but here are a couple work arounds:

Just update the timestamp manually and set it to the current timestamp.

Aside from that you can use 'set timestamp' to set the time used for
the timestamp (this is how it's done when you are using replication).

We also offer a wide range of MySQL and PostgreSQL training -
http://www.otg-nc.com

--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
Ike wrote:
I havea timestamp field in a table which shows the timestamp of the last
update or insert to a given row. Is there a way to temporarily turn that
off, such that I can update a row withOUT affecting timestamp? Thanks, Ike


Jun 5 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Lars Plessmann | last post by:
how can I generate a mysql timstamp value of the current time? sample: 20040605042505 YYYYMMDDhhmmss is it only possible by concat year.month.day.hours.minutes.seconds or is there any final...
0
by: Jim Moseby | last post by:
I stumbled across this while trying to update a table with a timestamp type column. At the time, I didn't know that the timstamp column would update itself when a row was changed. A kind gentleman...
3
by: Ina Schmitz | last post by:
Hello all, I would like to import a comma separated values file to DB2 UDB 8.2. This file also contains values of type DATE and TIMESTAMP having for example the following format 900925...
4
by: P. George | last post by:
i have a table with a 'timstamp with time zone' column. when i insert into it: '18 Nov 2004 00:00:00 PST' ....it looks like: 2004-11-18 03:00:00-05
3
by: peesz | last post by:
After upgrade ODBC Client from version 7.2 to 8.1 (FixPack 10) a have problem with tables where primary key is set to timestamp filed. In version 7.2 TIMESTAMP was mapped in MS Access as...
1
by: Nadav | last post by:
Hi Guys, This should be something simple or not possible at all, I have a ‘.pvk’ file and I want to generate a corresponding .spc file, I have followed the instructions on...
0
by: jaimebienlesfruits | last post by:
Is there a script I can include on the bottom of each page to indicate when the page was last updated? The PHP timstamp thing doesn't seem to work as it reflects the date of visit on the user's part....
3
by: Michael Voss | last post by:
Hello! I have to sign my assembly (WinForms C# 1.1) with a string name. Unfortulately, I'm forced to reference another assembly (no COMInterop Wrapper) not being signed with a strong name. This...
4
by: afarfanmadrid | last post by:
I am using mktime to convert the localtime value to timstamp. I am in CET zone, The returned string of the function localtime, it is correct, it matches with the date command in the shell. But the...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.