conver microsecond timestamps using the date/time functions