DBA tips & tricks: Querying for the current date!
A quick round-up of my favorite tips & tricks for database administration! If there is a difference in method /query structure between T-SQL, Postgres or MySQL I will make sure to point it out. The assumption is that the version of SQL is current to the date of this posting.
Querying for the current date!
There are a lot of scenarios you’ll want to get the server's current time. Say you want to throw some of the latest data you have into your ML model to train it, or you have to get a subset of your…