diff options
| author | unknown <arjen@fred.bitbike.com> | 2002-05-21 10:04:34 +1000 |
|---|---|---|
| committer | unknown <arjen@fred.bitbike.com> | 2002-05-21 10:04:34 +1000 |
| commit | 958532917de630b88f636a41a817866e3f3554af (patch) | |
| tree | 4d2ede00f8e6c21e4ea581f396be66f7b5f067b7 | |
| parent | 2e852ebfb61dfb14aa9e75ba8b53ea057a61182c (diff) | |
| download | mariadb-git-958532917de630b88f636a41a817866e3f3554af.tar.gz | |
Clarification of UNIX_TIMESTAMP() limited range checking.
| -rw-r--r-- | Docs/manual.texi | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi index 2d11e5a7c67..9042117f9b5 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -32499,8 +32499,9 @@ mysql> SELECT UNIX_TIMESTAMP('1997-10-04 22:23:00'); When @code{UNIX_TIMESTAMP} is used on a @code{TIMESTAMP} column, the function will return the internal timestamp value directly, with no implicit ``string-to-unix-timestamp'' conversion. -If you give @code{UNIX_TIMESTAMP()} a wrong or out-of-range date, it will -return 0. +If you pass an out-of-range date to @code{UNIX_TIMESTAMP()} it will +return 0, but please note that only basic checking is performed +(year 1970-2037, month 01-12, day 01-31). If you want to subtract @code{UNIX_TIMESTAMP()} columns, you may want to cast the result to signed integers. @xref{Cast Functions}. |