How to update timestamp field in PostgreSQL table?

Question

PostgreSQL

In the table, each user has a lastLogin field, the timestamp data type, how to update this field each time the user logs in? I try like this -

'UPDATE users SET lastLogin = timestamp with time zone WHERE email = email is not updated

Answer 1

For example like this:

UPDATE users 
SET lastLogin = CURRENT_TIMESTAMP
WHERE email = '[email protected]'
;

PostgreSQL fiddle