field with default current_timestamp on update

[Former Member]

Hi,

   how can I update a timestamp during an update of a record?

example mysql: ON UPDATE CURRENT_TIMESTAMP but on sap Hana does not work.

Do you have a solution?

genereted as always with CURRENT_TIMESTAMP does not work

ALTER TABLE A_TEST  ADD (B TIMESTAMP GENERATED ALWAYS AS CURRENT_TIMESTAMP NOT NULL) ;

error:

SAP DBTech JDBC: [458]: unsupported function included: CURRENT_TIMESTAMP is not supported by generated column

I have already read these discussions:

http://scn.sap.com/thread/3389447

http://scn.sap.com/thread/3400259

Do you have other examples?

Thank You

[lbreddemann]

What is your requirement here?

Why does anyone has an interest in when a record has been changed on DB level?

[Former Member]

I have to delete some records but I have to know if they were changed before deleting

[rasmus_seidelinstokholm]

Hi Giulio,

I have the same requirement, did come up with any solution?