This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I want to convert string value to datetime using formula in-db tool. Below is my sample data:
20180401102000 (string) ---> 2018-04-01 10:20:00
I know how to achieve this without in-db tool, but my requirement is to do this in in-db tool.
What is the datasource (oracle, sql server, etc)? The help file is very useful for this tool https://help.alteryx.com/11.8/index.htm#cshid=LockInFormula.htm
This isn't the solution but an example that might be close to what you are looking for if you were using SQL Server for example:
Cast('7/7/2011' as datetime)
The other option is to use the WRITE DATA IN DB tool and essentially create a lookup table.
Thank you for response.
Datasource is impala.
I want to use this formula either in select statement in 'Connect in-db' tool or formula in-db tool in the workflow.
for ex: Select TO_DATE('column_name','MM/DD/YYYY HH:MI:SS') from table ---> in 'connect in-db' tool.