Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I don't have access to the database directly and I want to know in which format is the date column of a view defined.
What is the equivalent of
show view viewname;
in qlikview?
I can connect to the database from qlikview only.
Try the statement: SQLTYPES;
You would insert this right after your connection string. But why not just read in the date column into QV without any transformations and then you'll see how it's defined?
Regards,
Vlad