Table of Contents | ||||
---|---|---|---|---|
|
...
Argument | Data type | Description | ||
---|---|---|---|---|
Timestamp mandatory | timestamp | You can either select a field with that data type or introduce it manually. In case you want to introduce it, note that this value should be a date: Year-Month_Day Hour:Minute:Second.Millisecond (yyyy-MM-dd HH:mm:ss.SSS) → You can skip seconds and milliseconds. | ||
Locale | 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:
|
...
Info |
---|
Be aware that timestamps taking place during summer will be affected in the time zones in which they set the clock forward during summer. For example, Europe/Madrid (CET-Central European Time), which is UTC+1, becomes UTC+2 during summertime and thus timestamps in August will be affected when using that time zone. Be also aware that summertime differs between the Northern and Southern Hemispheres. |
Example
In the demosiem.logtrust.ecommerceweb.dataactivity
table, we want to create a field that indicates the week of the year of the dates in our eventdate field. To do it, we will create a new field using the Week of the year operation.
...
You can copy the following LINQ script and try the above example on the demosiem.logtrust.ecommerceweb.dataactivity
table.
Code Block |
---|
from demosiem.logtrust.ecommerceweb.dataactivity select weekofyear(eventdate) as week_of_year |
...