Here is my insert statement.
CREATE VOLATILE TABLE A (ClickLoad_Dt DATE FORMAT 'yyyy/mm/dd');
INSERT INTO A(ClickLoad_Dt)
SELECT MAX(CAST (click_dt AS DATE FORMAT 'yyyy/mm/dd') ) FROM B;
SELECT * FROM A
I get and empty table even though the answer to below query is 5/25/2015
SELECT MAX(click_dt) FROM B
I am not able to figure out what is happening. I appreciate all the help I can get.