Table of Contents | ||||
---|---|---|---|---|
|
...
How does it work in the search window?
Select Create column field in the search window toolbar, then select the Tomorrow operation.
This operation can be applied with no arguments. In this case, you will get the start time of the current day considering your current time zone. If you add the Time zone argument, you can specify a timezone different than your current one to see the time your time zone presents when the following day starts in the specified time zone. When assigning a time zone different to yours, pay special attention to the original timestamp of the event, as the result may imply a day shift in the time zone specified.
Argument | Data type | Description | ||
---|---|---|---|---|
Time zonemandatory | string | You need a valid string format the app can recognize so it returns meaningful results. If you leave the field empty or introduce a value the app cannot recognize, the default Time Zone is UTC. You can use one of the following methods:
|
The data type of the new column field values is timestamp.
Info |
---|
Be aware that in some time zones they set the clock forward during summer and thus the results will be altered. For example, Europe/Madrid (CET-Central European Time), which is UTC+1, becomes UTC+2 during summertime. Performing this operation during summer with that time zone selected as your own or using it as an argument will affect the results. Be also aware that summertime differs between the Northern and Southern Hemispheres. |
Example
In the demo.ecommerce.data
table, we want to create a column field showing the start time of the following day (today is January 16th16th) taking as reference the EET (Eastern European Time, UTC+2) and considering we are in CET (Central European Time, UTC+1). To do it, we will create a new column field using the Tomorrow operation.
The arguments needed to create the new column field are:
Time zone - EET
...
Click Create columnfield and you will see the following result:
The new column field shows that when the following day (January 17th) started in ETT (UTC+2), it was 23 hours of January 16th in CET (UTC+1).
...
Use the operator select
... as
... and add the operation syntax to create the new columnfield. These are the valid formats for the Tomorrow operation:
tomorrow()
→ Use this expression to get the start time of the following day, according to your current time zone.tomorrow(timezone_string)
→ Use this expression to get the start time of the following day, according to the specified time zone.
Example
You can copy the following LINQ script and try the above example on the demo.ecommerce.data
table.
Code Block |
---|
from demo.ecommerce.data select tomorrow("EET") as Tomorrow_start_EET |