Tableau string is converted to a date format-CodePudding

Home > database > Tableau string is converted to a date format

Tableau string is converted to a date format

Time：10-10

201701 excuse me so I want to change into a date format string but it is null, how should I solve ah, have bosses know?

CodePudding user response:

 
SQL> The select to_date (' 201701 ', 'yyyymm') result from dual; 
The RESULT 
-- -- -- -- -- -- -- -- -- -- -- 
The 2017-01-01 

SQL>