Skip to Content
author's profile photo Former Member
Former Member

field with default current_timestamp on update

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

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Apr 07, 2015 at 11:16 PM
    -3

    What is your requirement here?

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

    Add comment
    10|10000 characters needed characters exceeded