Available date and time conversions depend on the datatype.
Subscribers implicitly convert TIME datatypes to BIGTIME datatypes by setting the microsecond portion to 0.
Subscribers implicitly convert DATETIME datatypes to BIGDATETIME datatypes by setting the microsecond portion to 0.
Subscribers implicitly convert DATE datatypes to DATETIME or BIGDATETIME datatypes by setting the time portion to 0.