sparkSQL Postgres / DateDiff is not coverting to date

48 Views Asked by At

//*DateDiff does not work in redash postgres SQl. Redash are auto foramtted to dd/mm/yyyy by default. How would I use to_char(date, 'mm/dd/yyyy') in this scenerio *//

--CASE WHEN actual_config_higher_assy.inst_DT_TM > cast('2046-12-31 06:28:13.000000' as timestamp(6)) THEN NULL ELSE cast(actual_config_higher_assy.inst_DT_TM as date) END, DATEDIFF(day, '1900-01-01T00:00:00', remis_restricted.actchb_xlt_vw.install_date)+2 AS WING_INST_DT remis_restricted.actchb_xlt_vw.remove_date


When I run this part in my statement, the results come out as a string. Column Wing_INST_DT Results 37,714.

I'm trying to covert it to date. 
0

There are 0 best solutions below