Question: I have 2 columns started\_at and ended\_at (both timestamps) and try to calculate the exact difference in minutes, but somehow it dont wanna work.
I've already looked for similar questions but it doesnt work for me..

| started\_at | ended\_at |
| --- | --- |
| 2021-01-02 16:22:53 UTC | 2021-01-02 16:43:40 UTC |
| ... | ... |

**What I have tried:**

```
    EXTRACT (DATE FROM started_at) AS start_ymd,
    EXTRACT (TIME FROM started_at) AS start_time,
    EXTRACT (DATE FROM ended_at) AS end_ymd,
    EXTRACT (TIME FROM ended_at) AS end_time

```

Results are in yyyy-mm-dd format but I dont know what to do with these extracts.

The **standard method** below works well with 2 single timestamps:

```
SELECT 

    TIMESTAMP("2010-07-07 10:20:00+00") AS later_timestamp,
    TIMESTAMP("2008-12-25 15:30:00+00") AS earlier_timestamp,

    TIMESTAMP_DIFF(TIMESTAMP "2010-07-07 10:20:00+00", TIMESTAMP "2008-12-25 15:30:00+00", HOUR) AS hours;

```

But I have **2 columns** with millions of data and I dont know how to calculate each timediff.
Thanks a lot guys, I am dealing with this little problem since 6 hours smh

Answer: 
I think you doesn't link your .css file

```
<link rel="stylesheet" href="css/your.css">

```
Tweak your CSS like this

```
.attachment-label {
font-size: 10px;
font-style: italic;
color: rgba(0, 0, 0, 0.5);}

```

You need to add single space after comma and expected a leading zero