Hi,
I have used current_timestamp, i am submitting same values then current_timestamp not updating.
I have used below for updating timestamp.
(timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)
Kindly help me to update timestamp, on every hit
Jump to PostGenerally, the timestamp field will not be updated unless the row has changed, update statement notwithstanding. IE, it is indicating when the row was physically updated.
There are a lot of priors on this. Read from https://www.google.com/search?q=UPDATE+CURRENT_TIMESTAMP&ie=utf-8&oe=utf-8#q=UPDATE+CURRENT_TIMESTAMP+NOT+WORKING&*
I wish you had shared more SQL statements so I could pick over that. But read the priors.
It is possible using trigger.
Can u please send the triiger code
Generally, the timestamp field will not be updated unless the row has changed, update statement notwithstanding. IE, it is indicating when the row was physically updated.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.
