fixes for time data type, time datatype now done