diff options
author | unknown <serg@serg.mysql.com> | 2001-03-01 22:46:35 +0100 |
---|---|---|
committer | unknown <serg@serg.mysql.com> | 2001-03-01 22:46:35 +0100 |
commit | 2ac92eb43c6d1c16ecb24529c5579739b2c352bb (patch) | |
tree | 0fd65b23f23fd839822deca111c9809dc93bbadf | |
parent | 8e035b499ee1b44e4ec8b002c84fc4347704bb7e (diff) | |
download | mariadb-git-2ac92eb43c6d1c16ecb24529c5579739b2c352bb.tar.gz |
manual.texi ``short'' TIME values issue clarified
Docs/manual.texi:
``short'' TIME values issue clarified
-rw-r--r-- | Docs/manual.texi | 17 |
1 files changed, 10 insertions, 7 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi index 69c1d8ad797..27b9b543016 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -14692,13 +14692,16 @@ seconds values that are less than @code{10}. @code{'8:3:2'} is the same as @code{'08:03:02'}. Be careful about assigning ``short'' @code{TIME} values to a @code{TIME} -column. @strong{MySQL} interprets values using the assumption that the -rightmost digits represent seconds. (@strong{MySQL} interprets @code{TIME} -values as elapsed time rather than as time of day.) For example, you might -think of @code{'11:12'}, @code{'1112'}, and @code{1112} as meaning -@code{'11:12:00'} (12 minutes after 11 o'clock), but @strong{MySQL} -interprets them as @code{'00:11:12'} (11 minutes, 12 seconds). Similarly, -@code{'12'} and @code{12} are interpreted as @code{'00:00:12'}. +column. Without semicolon, @strong{MySQL} interprets values using the +assumption that the rightmost digits represent seconds. (@strong{MySQL} +interprets @code{TIME} values as elapsed time rather than as time of +day.) For example, you might think of @code{'1112'} and @code{1112} as +meaning @code{'11:12:00'} (12 minutes after 11 o'clock), but +@strong{MySQL} interprets them as @code{'00:11:12'} (11 minutes, 12 seconds). +Similarly, @code{'12'} and @code{12} are interpreted as @code{'00:00:12'}. +@code{TIME} values with semicolon, instead, are always treated as +time of the day. That is @code{'11:12'} will mean @code{'11:12:00'}, +not @code{'00:11:12'}. Values that lie outside the @code{TIME} range but are otherwise legal are clipped to the appropriate |