Question: I am using the following select statement to enter the a record in a cartodb database.

```sql
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.

Answer: 
Is it UTC?  

Current UTC time: 3:41 AM Thursday, March 31, 2016  

My local time: 8:41 PM Wednesday, March 30, 2016

[Coordinated Universal Time (UTC)](https://en.wikipedia.org/wiki/Coordinated_Universal_Time)
Once you know in which time zone the data was collected ([here](http://www.timeanddate.com/time/zones/caribbean) you have a list of all the Caribbean time zones), you can update your date column with the following SQL query:

```
UPDATE TABLE_NAME
SET DATE_COLUMN = DATE_COLUMN AT TIME ZONE 'CODE'

```