open:timestamp-with-timezone

Timestamp with Timezone

snippet.sql
UPDATE EVENT_VIDEO_CHASE_INFO
SET VIDEO_CHASE_COMPLETE_YN = 'Y',
	VIDEO_CHASE_COMPLETE_DATE = TO_CHAR(#{SendTime}::TIMESTAMPTZ, 'YYYYMMDDHH24MISS')
WHERE EVENT_SEQ = #{event_seq}
	AND VIDEO_CHASE_NO = CAST(#{video_chase_no} AS INTEGER)

  • open/timestamp-with-timezone.txt
  • 마지막으로 수정됨: 2020/06/02 09:25
  • 저자 127.0.0.1