Contents x
    How to specify the time zone in the transfer destination column representing the time
    • 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Contents

    How to specify the time zone in the transfer destination column representing the time

    • Updated on 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    Note

    This is a machine-translated version of the original Japanese article.
    Please understand that some of the information contained on this page may be inaccurate.

    summary

    If you want to express the time in a specific time zone, such as Asia/Tokyo, in the forwarding destination specification column, you can achieve it by taking the following steps.

    1. In the target transfer settings, click Add Column in Item column settings on the "STEP2 Data Preview / Advanced Settings" output options tab.

    * The following is an example when BigQuery is specified as the forwarding destination.

    image.png

    image.png

    1. Make the following settings for the added items.
    • Column name: < column name that you want to express in a specific time zone>
    • Data type:DATETIME or timestamp ※See supplement
    • Date format: <Any format> * Some data types do not require input.
    • Timezone: JST

      image.png

    1. Click on the Output option.

    2. Run the transfer job and confirm that the data transfer occurred in the specified time zone.

    If you have any other questions or consultations about using the service, please contact Customer Success.

    supplement

    If the transfer job fails due to data type inconsistency, it may be resolved by setting the transfer mode to REPLACE in the transfer destination settings in "STEP1 Transfer Source / Destination Settings".

    Was this article helpful?
    What's Next