In CS50 pset 7, there is a part where you have to use SQL to insert the date and time of a transaction into a table.
According to the web, there is a function to do that called CURRENT_TIMESTAMP or NOW(). However, it's not clear to me exactly how to use these. I tried a few google searches but was still struggling to figure this out.
$result3=query("INSERT INTO History (Date/Time, Symbol, Shares, Buy/Sell) VALUES (CURRENT_TIMESTAMP, ?, ?, ?)", $stock["symbol"], $shares_to_buy, 1);
The above is apparently NOT how you do it.