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.