How to add modified date into database?

PHP
1

I am new to php. :frowning:

I have a record in my database, when i change the record and update, the modified date should automatically get insert into database.

what are all the steps i need to take?

2

Use NOW() in your Update statement


UPDATE
    mytable
SET
     field1 = 'value1'
   , field2 = 'value2'
   , datefield = NOW()
// etc
3

thank you so much… :slight_smile:

4

I am also agree.Now() will be used in the update query to display the current date and time.It returns the yyyy-mm-dd and also HH:MI:SS.