We are trying to insert datetime values with the following query - insert into products (name,createdon) values ('product1', now()) We are firing a raw query using sequelize. The value is being stored in UTC format.
Firing the same query directly from MySQL, stores the value in local time.
We need the value stored in local time and not in UTC. How do we achieve that here?