These are chat archives for getredash/redash
Rethinking how data is queried, shared and visualized. A web application that allows to easily query an existing database, share the dataset and visualize it in different ways. Oh and you can also create dashboards.
sudo -u redash psql
hi, I need to convert a varchar column to datetime. the existing date format is like '06/15/2016 10:12:17'
I tired select to_date('06/15/2016 10:12:17','yyyy-MM-dd HH:MI:SS.SSSSS');
But it gives me 07/09/12, which is not right
can anybody help me on this please ?
select convert(datetime,'06/15/2016 10:12:17',102) --- this works in sql server but not in redash
I believe some other conversion needs to be done
Can anybody please assist me ?
@contractor05 What database are you using?
Btw, this is a general SQL question and not Redash specific. You might have better luck with something like StackOverflow.
@arikfr when I run the query select convert(datetime,'06/15/2016 10:12:17',102) in redash I am getting below error
Error running query: syntax error at or near "," LINE 1: ...74ab7 */ select convert(datetime,'06/15/2016 10:12:17',102); ^
Getting following error when I am trying to connect impala
Error running query: could not connect to server: Connection timed out Is the server running on host "192.168.3.164" and accepting TCP/IP connections on port 5432?
select convert(varchar(19),'06/15/2016 10:12:17',102)