Starting from Denodo Platform 7.0, Denodo allows users to extract milliseconds from the** timestamp values **by using the Datetime Function [GETTIMEINMILLIS](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/datetime_functions/datetime_functions#gettimeinmillis). I was able to successfully extract milliseconds from the timestamp values in a view using GETTIMEINMILLIS as below:
` SELECT gettimeinmillis(field_1) as millisecond FROM view_1;`
Hence, in your scenario, I would check the **‘vdp.log’ **file found under the “<DENODO_HOME>\logs\vdp” folder to find if there are any errors.
Hope this helps!