date values are 'value_date', not 'Date'. On SQL Server, milliseconds were actually NOT cut off.