Milliseconds based on Table Values

[bleu]

I need to get the milliseconds out of a database, using a SQL statement, based on the values in the TransDate column. I know Alteryx doesn't like milliseconds so if I could get it in another column that would work just fine. But I need those values. So for the first value below the data would be 857.

Any advice would be appreciated.

Database:

[echuong1]

In the SQL query used to bring the data into Alteryx, you can try casting it as a string value rather than a timestamp. Then, you should be able to handle the full values in Alteryx or parse as needed.