problem with Timestamp

[josemaria_cabre]

Hi,

I have a problem converting a field (Create Date) to timestamp, as it is swapping year and Day.

Using an example from this table, 01-03-19 16:14 should be converted to 01/03/2019 16:14:00, where 01 is day and 19 is year, but it is converting to 2001/03/19 16:14:00

I tried changing parameters from main section in script, but it didn't work either

Can anyone help with this issue pls?

Thanks in advance,

Jose

[kaushiknsolanki · Accepted solution]

Try this.

Load *, Timestamp(Timestamp#([Create Date],'MM-DD-YY hh:mm'),'YYYY/MM/DD hh:mm:ss') as NewField

From XYZ;

Regards,

Kaushik Solanki

[josemaria_cabre]

Worked perfect.

Thanks for your help Kaushik!

[kaushiknsolanki]

Good to hear that.

Cheers.

Regards,

Kaushik Solanki