SQL DateTime conversion failing

[#1]

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?

[#2]

Hi Miguel

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

Lukasz

[#3]

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.

[#4]

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

Can you upload the document?

[santharubban]

try this

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

i think thi swill help you.

[maxgro]

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)

[#7]

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.