I have a column that is of type "timestamp" in format of 2010-09-04 22:24:19 . I need to run a process where I check today's date against any records that have been created today already (marked by timestamp).
So essentially if i do select curdate(); it'll give me back 2010-09-06. I want to compare that to the timestamp to see if this is the same day (so ignore the hh:mm:ms).
I dont want to do substring(TS, 1,10 ) where I'll have 2010-09-04 and i'll be able to compare strings... I want to do a DATE comparison.
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…