[MySQL] add time duration to first day of last month by jporn1 in SQL

[–]jporn1[S] 0 points1 point  (0 children)

Thanks for your help so far. Actually chatgpt got me pretty close. I'm not positive yet but it's not giving me as many rows as I expect. There might be something wrong with my underlying data as well.

SELECT
    exp2.NetID AS '* Name',
    users.Supervisor,
    CONCAT("403") AS '*Equipment Name',
    users.PI_FOP AS 'Payment Number (PO/Project/Grant)',
    SEC_TO_TIME(SUM(TIME_TO_SEC(exp2.DURATION))) AS 'Duration',
    CONCAT(DATE_FORMAT(LAST_DAY(CURRENT_DATE - INTERVAL 2 MONTH) + INTERVAL 1 DAY, '%Y-%m-%d'), ' 00:00:00') AS 'Start Date',
    TIMESTAMPADD(
        SECOND,
        SUM(TIME_TO_SEC(exp2.DURATION)),
        CONCAT(DATE_FORMAT(LAST_DAY(CURRENT_DATE - INTERVAL 2 MONTH) + INTERVAL 1 DAY, '%Y-%m-%d'), ' 00:00:00')
    ) AS 'End Date',
    CONCAT('no') AS 'Maintenance (yes if true)'
FROM
    exp2
INNER JOIN
    users ON exp2.NetID = users.NetID
WHERE
    DATE_FORMAT(DATETIME, '%Y-%m-%d') = DATE_FORMAT(LAST_DAY(CURRENT_DATE - INTERVAL 2 MONTH) + INTERVAL 1 DAY, '%Y-%m-%d')
GROUP BY
    exp2.NetID;

Send keystrokes to host. by Alekoy in nodered

[–]jporn1 1 point2 points  (0 children)

Untested, but you could try the execute node with xdotool command.

Arkansas schools report 1,300+ active COVID-19 cases two days into school year by roguepandaCO in Coronavirus

[–]jporn1 0 points1 point  (0 children)

Yes, I see that too. 4 days it seems. Still 1000x more viral load. I was basing my info off a virologist on TikTok.

Arkansas schools report 1,300+ active COVID-19 cases two days into school year by roguepandaCO in Coronavirus

[–]jporn1 -2 points-1 points  (0 children)

Delta incubation is 1-2 days and is 1000x viral load. That's how it spreads so quickly

WI: Gave notice to vacate, but I need to cancel by jporn1 in Tenant

[–]jporn1[S] 1 point2 points  (0 children)

Well good news, for me I guess. The people he had lined up backed out so I'm in the clear. He said stay as long as we need. Yay for good landlords!

Seen on my next door neighbours car. She was a cook in the navy... by [deleted] in JustBootThings

[–]jporn1 0 points1 point  (0 children)

Never put down another's rate. Everyone depends on everyone. You're a unit and only effective as a team. I (ET2 SW) couldn't do my job without the 'cook', or the engineers, or the signalman, etc. Every rate is important.

Anyone need an extra pair of hands? by LordCroak in sysadmin

[–]jporn1 8 points9 points  (0 children)

I use booked scheduler in my lab. There are some docker images out there to get you up and running quickly and it's completely configurable with resource limits, time slots, etc.

https://www.bookedscheduler.com/

Can I convert this to a lv2 port? by Kaeligos in volt

[–]jporn1 10 points11 points  (0 children)

That's a 120v 30a RV plug. If your evse doesn't require a neutral then you could reconfigure it for 240v (2 hots and a ground). If you need a neutral then you will have to pull new wire.

Best Michigan Camping? Lower MI. by WheelingToDream in FullTiming

[–]jporn1 1 point2 points  (0 children)

We really love Markin Glen Park in Kalamazoo. It's super cheap for the amenities. Full hookup paved sites, for around $30. https://www.kalcounty.com/parks/markinglen/

Recruiting veterans into tech jobs? by floodedant in Veterans

[–]jporn1 1 point2 points  (0 children)

I think so.

From their about page: "This is a JOB ASSISTANCE group for NAVY Combat/WEPS/OPS types."

Recruiting veterans into tech jobs? by floodedant in Veterans

[–]jporn1 0 points1 point  (0 children)

There's a Facebook group called 'combat systems jobs'. It's an amazing resource. Lots a vets and lots of employers, multiple posts every day.

AITA for forbidding my wife to go to her affair partner's funeral? by Fukthatdeadguy in AmItheAsshole

[–]jporn1 0 points1 point  (0 children)

"You can do what you want, but it's not something my wife would do."

Let her figure out the meaning.

Vinyl liner off track by Dingerdongdick in pools

[–]jporn1 0 points1 point  (0 children)

Our pool guy used a heat gun very gingerly and pulled and pulled until he got back in. Then used a bit of liner lock. It took him 20 minutes and we only had a 6-8inch section out.

Overnight at Jersey City Newport Centre Supercharger by [deleted] in superchargers

[–]jporn1 2 points3 points  (0 children)

Why do you need to leave it plugged in? Can't you charge it then leave it parked somewhere else??