Well, timestamp values are actually just numbers. By marking a field as a Timestamp field you give a hint to Qlik Sense to treat the field as a timestamp instead of just a number. So it will apply the default timestamp format to it for you. I'm afraid that Qlik Sense isn't smarter than that at the moment. So, yes, you'll have to change the setting for each field from General to Timestamp yourself. Or just leave them as they are and do the formatting in the front end chart objects.
well, its quite an effort ya. so still no way around for this ya? every table consisted timestamp columns we have to flag that as timestamp in qliksense again even in the original database the columns is in timestamp format?
is the Set Timestamp format in the beginning of load script has anything to do with this?