Question: I am working on a project for a client. The project seems to work fine in the old Android Studio, but ever since I updated my studio to 2.2.2, I am getting the sync error when trying to run the app, the error message is as posted below.

```
Error:Execution failed for task ':app:transformResourcesWithMergeJavaResForDebug'.
    > com.android.build.api.transform.TransformException: com.android.builder.packaging.DuplicateFileException: Duplicate files copied in APK META-INF/LICENSE
         File1: /home/empressum/.gradle/caches/modules-2/files-2.1/org.apache.httpcomponents/httpclient-android/4.3.5.1/eecbb0b998e77629862a13d957d552b3be58fc4e/httpclient-android-4.3.5.1.jar
         File2: /home/empressum/.gradle/caches/modules-2/files-2.1/org.apache.httpcomponents/httpmime/4.3/5b0002c5fb66867ca919be0fbd86de1cfaf76da7/httpmime-4.3.jar

```

Answer: 
I prefer using `interval` for this:

```
select deliverydate + interval '2' hour
from the_table;

```

The above is standard SQL and works well in Oracle. 

More details in the manual: <https://docs.oracle.com/database/121/SQLRF/sql_elements003.htm#SQLRF00221>
MS Access Update Query:
-----------------------

```
UPDATE Table1 AS t2 INNER JOIN Table1 ON t2.ID = Table1.ID 
SET Table1.DeliveryDate = DateAdd("h",2,[t2].[DeliveryDate]);

```

Sql Server Update Query:
------------------------

```
UPDATE Table1 AS t2 INNER JOIN Table1 ON t2.ID = Table1.ID 
SET Table1.DeliveryDate = DateAdd("hh",2,[t2].[DeliveryDate]);

```

MS Access Select Query:
-----------------------

```
SELECT DateAdd("h",2,Table1.DeliveryDate) AS NewDateTime
FROM Table1;

```

Sql Server Select Query:
------------------------

```
SELECT DateAdd("hh",2,Table1.DeliveryDate) AS NewDateTime
FROM Table1;

```

Oracle Select Query:
--------------------

```
SELECT (Table1.DeliveryDate + 2/24) AS NewDateTime
FROM Table1;

```