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.

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

Use timestamp column in where clause #46

Open
nikhilv-quantela opened this issue Apr 20, 2018 · 0 comments
Open

Use timestamp column in where clause #46

nikhilv-quantela opened this issue Apr 20, 2018 · 0 comments

Comments

@nikhilv-quantela
Copy link

Unable to use timestamp, for example:
"what is minimum monoxide in pollution_data when time_stamp equals 2017-03-23"

my timestamp has both time and date.

Also tried using:
"what is minimum monoxide in pollution_data when extract(month from time_stamp) equals 3"

datatypes are:-
time_stamp timestamp with time zone,
monoxide double precision,

P.S.: not using real names of columns and table for privacy reasons

@FerreroJeremy FerreroJeremy changed the title unable to use timestamp column in where clause Use timestamp column in where clause Apr 23, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants