topic Re: SQL DateTime conversion failing in QlikView

SQL DateTime conversion failing

Tue, 04 Feb 2014 16:53:03 GMT

In the following DateTime (SDate) from SQL I get 2 digits of the year part cutted:

InputTable:

SQL SELECT "Snapshot_Date"

from dbo."IN_Contracts"

Generic Load Timestamp(Snapshot_Date,'YYYY-MM-DD HH:MM:SS.FFF') as SDate Resident InputTable;

This works:

Load Timestamp(Snapshot_Date,'YYYY-MM-DD HH:MM:SS.FFF') as SDate Resident InputTable;

Seems to be a problem with the generic load?

Tue, 04 Feb 2014 16:56:22 GMT

Hi Miguel

What are you trying to achieve loading one column with generic load?

Lukasz

Tue, 04 Feb 2014 16:58:21 GMT

Well I'm loading more columns, I just cut the code to the essential to not confuse people.

Basically I'm in the process of converting a generic database to a concrete one.

Tue, 04 Feb 2014 17:00:07 GMT

I'm afraid it was even more confusing with one column

Can you upload the document?

santharubban — Tue, 04 Feb 2014 17:00:52 GMT

try this

Load Timestamp(Snapshot_Date,'YYYY-MM-DD HH:MM:SS[.FFF]') as SDate

i think thi swill help you.

maxgro — Tue, 04 Feb 2014 18:04:23 GMT

It seems to me you're missing some other colums in generic load

Adding 2 other columns your generic load works (or at least there are no syntax errors)

Wed, 05 Feb 2014 11:10:50 GMT

Here's attached my file. Now it doesn't show up any data!!!!

Maybe I'll do another example with an inline table since you guys cannot have access to my sql database.