issue_comments

Table actions

1 row where author_association = "NONE", issue = 1615596004 and user = 127195910 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

user 1

  • Karimat22 · 1 ✖

issue 1

  • illustrate time offset arithmetic · 1 ✖

author_association 1

  • NONE · 1 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
1460890139 https://github.com/pydata/xarray/issues/7596#issuecomment-1460890139 https://api.github.com/repos/pydata/xarray/issues/7596 IC_kwDOAMm_X85XE2ob Karimat22 127195910 2023-03-08T21:18:48Z 2023-03-15T04:59:54Z NONE

Time offset arithmetic involves adding or subtracting a duration from a specific time to obtain a new time. This is commonly used when dealing with time zones or calculating time differences between two events.

For example, suppose the current time is 3:30 PM in New York City, which is in the Eastern Time Zone (ET). We want to calculate what time it is in Los Angeles, which is in the Pacific Time Zone (PT), considering the 3-hour time difference between the two zones.

To do this, we can use time offset arithmetic by subtracting 3 hours from the current time in ET:

3:30 PM ET - 3 hours = 12:30 PM PT

Therefore, the current time in Los Angeles is 12:30 PM.

Another example of time offset arithmetic is when calculating the duration between two events. Suppose an event starts at 9:00 AM and ends at 10:30 AM. We can calculate the duration of the event by subtracting the start time from the end time:

10:30 AM - 9:00 AM = 1 hour 30 minutes

Therefore, the event lasted for 1 hour and 30 minutes.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   illustrate time offset arithmetic 1615596004

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [issue_comments] (
   [html_url] TEXT,
   [issue_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [updated_at] TEXT,
   [author_association] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [performed_via_github_app] TEXT,
   [issue] INTEGER REFERENCES [issues]([id])
);
CREATE INDEX [idx_issue_comments_issue]
    ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
    ON [issue_comments] ([user]);