You need to remove the '' that are wrapping the timestamp This example works fine and I get the timestamp correctly :
.ingest inline into table MyTable <| Text1, datetime(2023-08-09 14:10:12.0000000) , Text2, Text3