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

SQL: Casting a timestamp as a number uses secs instead of millis #37655

Closed
matriv opened this issue Jan 21, 2019 · 1 comment
Closed

SQL: Casting a timestamp as a number uses secs instead of millis #37655

matriv opened this issue Jan 21, 2019 · 1 comment
Assignees
@matriv
Labels
:Analytics/SQL SQL querying >bug

Comments

@matriv
Copy link
Contributor

matriv commented Jan 21, 2019 

SELECT CAST(hire_date AS LONG) FROM test_emp WHERE emp_no = 10001;

gives:

CAST(hire_date AS LONG)
-----------------------
520128000
@matriv matriv added >bug :Analytics/SQL SQL querying labels Jan 21, 2019
@elasticmachine
Copy link
Collaborator

Pinging @elastic/es-search

@matriv matriv self-assigned this Jan 21, 2019
@matriv matriv mentioned this issue Jan 22, 2019
Merged
matriv added a commit to matriv/elasticsearch that referenced this issue Jan 25, 2019
@matriv
SQL: Fix casting from date to numeric type to use millis
615d56f 
Previously casting from a DATE[TIME] type to a numeric (DOUBLE, LONG,
INT, etc. used seconds instead of the epoch millis.

Fixes: elastic#37655
@matriv matriv mentioned this issue Jan 25, 2019
Merged
matriv added a commit that referenced this issue Jan 25, 2019
@matriv
SQL: Fix casting from date to numeric type to use millis (#37869)
d1ff450 
Previously casting from a DATE[TIME] type to a numeric (DOUBLE, LONG,
INT, etc. used seconds instead of the epoch millis.

Fixes: #37655
matriv added a commit that referenced this issue Jan 25, 2019
@matriv
SQL: Fix casting from date to numeric type to use millis (#37869)
4003b11 
Previously casting from a DATE[TIME] type to a numeric (DOUBLE, LONG,
INT, etc. used seconds instead of the epoch millis.

Fixes: #37655
matriv added a commit that referenced this issue Jan 25, 2019
@matriv
SQL: Fix casting from date to numeric type to use millis (#37869)
5813f6c 
Previously casting from a DATE[TIME] type to a numeric (DOUBLE, LONG,
INT, etc. used seconds instead of the epoch millis.

Fixes: #37655
matriv added a commit that referenced this issue Jan 25, 2019
@matriv
SQL: Fix casting from date to numeric type to use millis (#37869)
2ce8347 
Previously casting from a DATE[TIME] type to a numeric (DOUBLE, LONG,
INT, etc. used seconds instead of the epoch millis.

Fixes: #37655
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@matriv matriv

Labels
:Analytics/SQL SQL querying >bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@matriv @elasticmachine