[MDEV-3813] UNIX_TIMESTAMP() reports decimal when date specified as string Created: 2012-10-19  Updated: 2014-06-20  Resolved: 2012-12-29

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.3.9
Fix Version/s: 5.3.12

Type: Bug Priority: Minor
Reporter: Robert Krzykawski Assignee: Timour Katchaounov (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Environment:

CentOS release 5.8 (Final) - Linux mdp01r.prod.marinsw.net 2.6.18-308.11.1.el5 #1 SMP Tue Jul 10 08:48:43 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux

Attachments: Text File UNIX_TIMESTAMP-MariaDB_5.5.25.txt    
Issue Links:
Duplicate
is duplicated by MDEV-3922 UNIX_TIMESTAMP() reports decimal when... Closed

 Description   

UNIX_TIMESTAMP() reports a decimal value when date string specified. Verified to work different on MySQL 5.5.9 (non MariaDB)
This bug was filed directly to maria-developers @ launchpad.net list too (using mysqlbug), but didn't get any response, so filing it here instead.. Can you guys verify if this is an issue or a "feature", and also cancel the launchpad.net list request?

 Comments   
Comment by Robert Krzykawski [ 2012-10-19 ]

Accidentally created this one under https://mariadb.atlassian.net/browse/IMT-7766

didn't look before creating.. Sorry

Generated at Thu Feb 08 06:51:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.