Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

cant use from_unixtime #1083

Closed
lifeinearth opened this issue Sep 9, 2016 · 1 comment
Closed

cant use from_unixtime #1083

lifeinearth opened this issue Sep 9, 2016 · 1 comment

Comments

@lifeinearth
Copy link

Edit Sqla Table> Expression > i add from_unixtime(mtime, '%Y-%m-%d %H:%i:%S'),
when Query the table, the sql change the next:

SELECT COUNT(*) AS count
FROM tp_pagesou
WHERE from_unixtime(mtime, '%%Y-%%m-%%d %%H:%%i:%%S') >= '2016-09-02 10:30:09.000000'
AND from_unixtime(mtime, '%%Y-%%m-%%d %%H:%%i:%%S') <= '2016-09-09 10:30:09.000000' LIMIT 50000

how to delete the %
@xrmx
Copy link
Contributor

xrmx commented Sep 11, 2016

Looks like a dup of #274. Closing.

@xrmx xrmx closed this as completed Sep 11, 2016
This was referenced Jun 2, 2021
Open
Open
Open
Open
zhaoyongjie pushed a commit to zhaoyongjie/incubator-superset that referenced this issue Nov 17, 2021
@kgabryje @zhaoyongjie
feat(plugin-chart-pivot-table): enable cross filtering (apache#1083)
67ee59d 
* feat(plugin-chart-pivot-table): enable cross filtering

* Fix test

* Fix tests

* Replace `.toEqual` with `.toMatchObject` to fix test

* Use jest.fn() to mock setDataMask

* Code review changes

* Bring back setting ownState
zhaoyongjie pushed a commit to zhaoyongjie/incubator-superset that referenced this issue Nov 24, 2021
@kgabryje @zhaoyongjie
feat(plugin-chart-pivot-table): enable cross filtering (apache#1083)
1e48622 
* feat(plugin-chart-pivot-table): enable cross filtering

* Fix test

* Fix tests

* Replace `.toEqual` with `.toMatchObject` to fix test

* Use jest.fn() to mock setDataMask

* Code review changes

* Bring back setting ownState
zhaoyongjie pushed a commit to zhaoyongjie/incubator-superset that referenced this issue Nov 25, 2021
@kgabryje @zhaoyongjie
feat(plugin-chart-pivot-table): enable cross filtering (apache#1083)
d96f3ed 
* feat(plugin-chart-pivot-table): enable cross filtering

* Fix test

* Fix tests

* Replace `.toEqual` with `.toMatchObject` to fix test

* Use jest.fn() to mock setDataMask

* Code review changes

* Bring back setting ownState
zhaoyongjie pushed a commit to zhaoyongjie/incubator-superset that referenced this issue Nov 26, 2021
@kgabryje @zhaoyongjie
feat(plugin-chart-pivot-table): enable cross filtering (apache#1083)
139a067 
* feat(plugin-chart-pivot-table): enable cross filtering

* Fix test

* Fix tests

* Replace `.toEqual` with `.toMatchObject` to fix test

* Use jest.fn() to mock setDataMask

* Code review changes

* Bring back setting ownState
This was referenced Feb 1, 2022
Open
Open
Closed
Open
@snyk-bot snyk-bot mentioned this issue Feb 21, 2022
Closed
@terrorizer1980 terrorizer1980 mentioned this issue Jun 22, 2022
Closed
This was referenced Sep 27, 2022
Open
Open
This was referenced Oct 6, 2022
Open
Open
Open
Open
@terrorizer1980 terrorizer1980 mentioned this issue May 24, 2023
Closed
@lili2311 lili2311 mentioned this issue Jul 4, 2023
Open
@terrorizer1980 terrorizer1980 mentioned this issue Jul 4, 2023
Closed
@mariasnyk mariasnyk mentioned this issue Jul 4, 2023
Open
@terrorizer1980 terrorizer1980 mentioned this issue Jul 5, 2023
Closed
@xiezhongfu xiezhongfu mentioned this issue Jul 5, 2023
Open
@xiezhongfu xiezhongfu mentioned this issue Nov 26, 2023
Open
@terrorizer1980 terrorizer1980 mentioned this issue Nov 29, 2023
Closed
@lili2311 lili2311 mentioned this issue Nov 29, 2023
Open
@terrorizer1980 terrorizer1980 mentioned this issue Nov 30, 2023
Closed
@xiezhongfu xiezhongfu mentioned this issue Dec 19, 2023
Open
This was referenced Dec 19, 2023
Closed
Closed
This was referenced Apr 29, 2024
Open
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@xrmx @lifeinearth