Workbench CHAR a timestamp

Greg_B

When i use..

 

 TO_CHAR((now() at time zone 'America/Chicago'),'YYYY-MM-DD HH12:MI')

 

Workbench uploads it as a date (Even though i have CHAR it).  How can i force Workbench to upload as a char?  I have also tried

 

 TO_CHAR((now() at time zone 'America/Chicago'),'YYYY-MM-DD HH12:MI')::VARCHAR   and there was no difference.  I have had success with forcing ::INTEGER on other fields that Workbench/Domo seem to not correctly analyze, but i am having trouble with this one. 

 

Ideas?

BlueRooster

I posted this link on your other question, but it may help with both situations. Let me know if you have any issues.

 

https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench/Workbench_4/05Understanding_the_Workbench_4_User_Interface#Schema