I am using the following select statement to enter the a record in a cartodb database.
INSERT INTO catch ( site_code, have_catch, fishtype1, fishtype2, fishtype3, fishtype4, fishtype5, number_of_species, **catch_date**, fisherman_id ) VALUES ( '$siteCode', 1, '$fishtype1', '$fishtype2', '$fishtype3', '$fishtype4', '$fishtype5', $numbFish, **now()**, '$fishermanId' );
The catch_date, created_at and updated_at dates being written is a day ahead if the actual date. E.g. 2016-03-31 instead of 2016-03-30.
Any idea as to the cause?
This is a recent issue that seems to have started after I upgraded to the latest version of cartodb.js.
Also, the data is being written to a database in my cartodb cloud account.
I'm not sure as to the time zone.