Changeset: 01e6518b281d for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=01e6518b281d
Modified Files:
sql/test/pg_regress/Tests/date.sql
sql/test/pg_regress/postgresql2sql99.sh
Branch: default
Log Message:
Added conversion rules for date 'today', date 'yesterday', date 'tomorrow'
diffs (56 lines):
diff --git a/sql/test/pg_regress/Tests/date.sql
b/sql/test/pg_regress/Tests/date.sql
--- a/sql/test/pg_regress/Tests/date.sql
+++ b/sql/test/pg_regress/Tests/date.sql
@@ -197,17 +197,27 @@ SELECT f1 - date '2000-01-01' AS "Days F
SELECT f1 - date 'epoch' AS "Days From Epoch" FROM DATE_TBL;
-SELECT date 'yesterday' - date 'today' AS "One day";
+SELECT current_date AS "today";
+SELECT sql_sub(current_date, 24*60*60.0) AS "yesterday";
+SELECT sql_add(current_date, 24*60*60.0) AS "tomorrow";
-SELECT date 'today' - date 'tomorrow' AS "One day";
+-- SELECT date 'yesterday' - date 'today' AS "One day";
+SELECT sql_sub(current_date, 24*60*60.0) - current_date AS "One day";
-SELECT date 'yesterday' - date 'tomorrow' AS "Two days";
+-- SELECT date 'today' - date 'tomorrow' AS "One day";
+SELECT current_date - sql_add(current_date, 24*60*60.0) AS "One day";
-SELECT date 'tomorrow' - date 'today' AS "One day";
+-- SELECT date 'yesterday' - date 'tomorrow' AS "Two days";
+SELECT sql_sub(current_date, 24*60*60.0) - sql_add(current_date, 24*60*60.0)
AS "Two days";
-SELECT date 'today' - date 'yesterday' AS "One day";
+-- SELECT date 'tomorrow' - date 'today' AS "One day";
+SELECT sql_add(current_date, 24*60*60.0) - current_date AS "One day";
-SELECT date 'tomorrow' - date 'yesterday' AS "Two days";
+-- SELECT date 'today' - date 'yesterday' AS "One day";
+SELECT current_date - sql_sub(current_date, 24*60*60.0) AS "One day";
+
+-- SELECT date 'tomorrow' - date 'yesterday' AS "Two days";
+SELECT sql_add(current_date, 24*60*60.0) - sql_sub(current_date, 24*60*60.0)
AS "Two days";
--
-- test extract!
@@ -269,3 +279,5 @@ SELECT DATE_TRUNC('CENTURY', DATE '0055-
SELECT DATE_TRUNC('DECADE', DATE '1993-12-25'); -- 1990-01-01
SELECT DATE_TRUNC('DECADE', DATE '0004-12-25'); -- 0001-01-01 BC
SELECT DATE_TRUNC('DECADE', DATE '0002-12-31 BC'); -- 0011-01-01 BC
+
+DROP TABLE DATE_TBL;
diff --git a/sql/test/pg_regress/postgresql2sql99.sh
b/sql/test/pg_regress/postgresql2sql99.sh
--- a/sql/test/pg_regress/postgresql2sql99.sh
+++ b/sql/test/pg_regress/postgresql2sql99.sh
@@ -56,6 +56,9 @@ sed -r \
-e 's/\bbox\b/string/ig' \
-e 's/\bpolygon\b/string/ig' \
-e 's/\bcity_budget\b/decimal(7,2)/ig' \
+ -e 's/\bdate 'yesterday'/sql_sub(current_date, 24*60*60.0)/ig' \
+ -e 's/\bdate 'today'/current_date/ig' \
+ -e 's/\bdate 'tomorrow'/sql_add((current_date, 24*60*60.0)/ig' \
-e 's/\bname,/string,/ig' \
-e 's/\bname$/string/ig' \
-e 's/LOG(numeric '10',/LOG10(/ig' \
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
