Bug #79890 | Function GREATEST(bigint, date) is not working as expected | ||
---|---|---|---|
Submitted: | 8 Jan 2016 12:10 | Modified: | 8 Jan 2016 14:36 |
Reporter: | Su Dylan | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.7.8 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[8 Jan 2016 12:10]
Su Dylan
[8 Jan 2016 14:36]
MySQL Verification Team
Hello Su Dylan, Thank you for the report. Imho this is expected behavior i.e if the arguments comprise a mix of numbers and strings(as in case of date '2006-11-14' which returns string), they are compared as numbers. Thanks, Umesh
[8 Jan 2016 14:42]
Peter Laursen
To compare as TIME: SELECT GREATEST (FROM_UNIXTIME(106168320), DATE '2006-11-14' ); -- returns 2006-11-14 00:00:00