When you are using Current date & time function to extract the scraping time during Cloud Run, you may find the time zone of exported data is UTC+0 by default, which may be different from your local time.
In this article, we will show you how to easily convert the timezone to your local time.
Note: Timezone conversion is only applicable for data in date & time format such as "YYYY-MM-DD HH: MM." You can use Reformat date & time to clean the data first: Refine extracted data (replace content, add a prefix, ..)
How to convert the timezone for current date & time field
Click the More button beside the Current time field
Choose Clean Data
Click Add Step
Choose Timezone conversion
Choose your preferred time zone from the dropdown list
Check the Output field to see the converted time, and then click Confirm if the converted time is the same as your preferred time.
How to convert timezone for data from webpage
Timezone conversion can also kick in when you want to convert the scraped data from your target website. For example, if you want to scrape the post date of a news article, you may want to convert the post time to your local time.
Timezone conversion relies on the timezone information provided in the scraped data. If the data does not include timezone details, you can use the Add a suffix feature to specify the timezone.
Giving an example:
Default time data: 2022-2-15 05:40 (Suppose your timezone is UTC+8)
Scraped time data: 2022-2-15 06:40 (which is a UTC+9 time as the website suggests)
You preferred output data: 2022-2-15 05:40
Steps to achieve that goal:
Click the More button next to your data field and choose Clean Data
Click Add Step, select Add a suffix
Enter +09:00 (which means UTC+9) in the text box, click Confirm
Click Add step again and select Timezone conversion
Choose your preferred timezone, check out the Output time, and click Confirm
