[MCOL-1391] TIME_FORMAT return NULL when trying to return time from a date column Created: 2018-05-04  Updated: 2021-02-20  Resolved: 2021-02-20

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.1.4
Fix Version/s: 5.5.1

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None

Epic Link: Time, Timestamp and Timezone

 Description   

Build tested: 1.1.4-1

Reference:

1 --------------
2 select cidx, CDATE, TIME_FORMAT(CDATE,'%h %i %s') from datatypetestm order by cidx
3 --------------
4
5 cidx CDATE TIME_FORMAT(CDATE,'%h %i %s')
6 1 1997-01-01 12 00 00
7 1 row in set
8
9 --------------
10 select cidx, CDATE, TIME_FORMAT(CDATE,'%H:%i:%s %f') from datatypetestm order by cidx
11 --------------
12
13 cidx CDATE TIME_FORMAT(CDATE,'%H:%i:%s %f')
14 1 1997-01-01 00:00:00 000000
15 1 row in set
16
17 --------------
18 select cidx, CDATE, TIME_FORMAT(CDATE,'%k:%i:%S') from datatypetestm order by cidx
19 --------------
20
21 cidx CDATE TIME_FORMAT(CDATE,'%k:%i:%S')
22 1 1997-01-01 0:00:00
23 1 row in set

ColumnStore:

1 --------------
2 select cidx, CDATE, TIME_FORMAT(CDATE,'%h %i %s') from datatypetestm order by cidx
3 --------------
4
5 cidx CDATE TIME_FORMAT(CDATE,'%h %i %s')
6 1 1997-01-01 NULL
7 1 row in set
8
9 --------------
10 select cidx, CDATE, TIME_FORMAT(CDATE,'%H:%i:%s %f') from datatypetestm order by cidx
11 --------------
12
13 cidx CDATE TIME_FORMAT(CDATE,'%H:%i:%s %f')
14 1 1997-01-01 NULL
15 1 row in set
16
17 --------------
18 select cidx, CDATE, TIME_FORMAT(CDATE,'%k:%i:%S') from datatypetestm order by cidx
19 --------------
20
21 cidx CDATE TIME_FORMAT(CDATE,'%k:%i:%S')
22 1 1997-01-01 NULL
23 1 row in set
Generated at Thu Feb 08 02:28:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.