Hive convert date format to to_date(timezone)

ex) '2018-12-03 15:00:00'
TO_DATE(FROM_UTC_TIMESTAMP(UNIX_TIMESTAMP(beg_date, 'yyyy-MM-dd HH:mm:ss') * 1000, 'GMT+9'))

ex) '2018-12-03T15:00:00Z'
TO_DATE(FROM_UTC_TIMESTAMP(UNIX_TIMESTAMP(end_date, "yyyy-MM-dd'T'HH:mm:ss'Z'") * 1000, 'GMT+9'))