Changeset: 839203059d83 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=839203059d83 Modified Files: sql/ChangeLog.Oct2020 Branch: Oct2020 Log Message:
Updated ChangeLog diffs (26 lines): diff --git a/sql/ChangeLog.Oct2020 b/sql/ChangeLog.Oct2020 --- a/sql/ChangeLog.Oct2020 +++ b/sql/ChangeLog.Oct2020 @@ -56,9 +56,20 @@ Instead do SET current_timezone = interval '1' hour; Casting between interval and other numeric types is no longer possible as well, because they are not compatible. - +- Because of incompatibilities this change may create, if an user intents + to convert a numeric value to an interval, the multiplication function + can be used in the form: <numeric value> * interval '1' <interval length> + e.g. 10 * interval '1' second = interval '10' second. + As for the other way around, the 'EPOCH' option was added to the extract + syntax. This option returns the number of milliseconds since the UNIX + epoch 1970-01-01 00:00:00 UTC for date, timestamp and time values (it + can be negative). Meanwhile, for day and second intervals, it returns the + total number of milliseconds on the interval. As a side note, the 'EPOCH' + option is not available for month intervals, because this conversion is + not transparent for this type. + * Mon Aug 31 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - Made general logarithm function log(x,base) compliant with the SQL standard, by swapping the input parameters. Instead of log(x,base), now is log(base,x). - + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
