Making sense of MariaDB addon time zone

Please help me understand,

  • I’m located in Israel
  • select now () in MariaDB gives me -3hrs ago (UTC I suppose)
  • state record saved right now is saved with created time stamp -6 hrs ago

Why is that?
That time zone is used to save records to the DB?

(Looking in the log and stuff in ha front end shows the correct time btw - I am only bothered by the time saved in the dB records since I want to query based on times)

Also interested