Format of timestamp "2904-02-20 01:00:00.0" gives null

[4b40af4694c4aaebfd86]

Hi all,

I have a column containing a timestamp.

To be sure that this column is interpreted correctly, I have to reformat it . I Use a "change column type " step with parameters 'Datetime' , 'yy-mm-dd hh:mm:ss' and 'yyyy*mm*dd*HH:MM:SS'.

But in some cases where the column = "2904-02-20 01:00:00.0", trifacta returns null instead of the actual value

Do you have an idea about what could be the cause of this problem ?

[Trifacta_Alumni]

Hi, Nadi--

Is "2904-02-20 01:00:00.0" the correct value?

If so, the year value is out of range of what the platform supports:

https://docs.trifacta.com/display/SS/Datetime+Data+Type

Cheers,

-SteveO

[4b40af4694c4aaebfd86]

Hi Steve,

Thanks for your answer.

Yes it is the correct value

Please can you tell me the max year value supported by the platform ?

Also I had a similar problem on a value where the year was = 0015, is this value also out of range?

Regards

[Trifacta_Alumni · Accepted solution]

Hi, Nadi--

Per the documentation link, here is the supported range for dates:

Supported Date Ranges: 

• Earliest: January 1, 1400
• Latest: December 31, 2599