{"id":2612,"date":"2022-09-24T11:50:04","date_gmt":"2022-09-24T11:50:04","guid":{"rendered":"http:\/\/kedar.nitty-witty.com\/?p=2612"},"modified":"2023-05-20T13:57:14","modified_gmt":"2023-05-20T13:57:14","slug":"providing-friday-proofs-to-mysql-consultants","status":"publish","type":"post","link":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants","title":{"rendered":"Providing Friday Proofs to MySQL Consultants | Scripts Functions  Routines"},"content":{"rendered":"\n<p>In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a &#8220;Friday&#8221;, so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to prove it. Prove it technically that it actually is a Friday.<\/p>\n\n\n\n<p>This blog post is my attempt to share the proofs of existence of a &#8220;Friday&#8221;.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Using MySQL datetime function: dayname<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>MySQL &#91;(Kedar)]&gt; select dayname(now());\n+----------------+\n| dayname(now()) |\n+----------------+\n| Friday         |\n+----------------+\n1 row in set (0.000 sec)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Running system command from MySQL prompt<\/h2>\n\n\n\n<!--more-->\n\n\n\n<pre class=\"wp-block-code\"><code>MySQL &#91;(Kedar)]&gt; \\! date +'%A'\nFriday\nMySQL &#91;(Kedar)]&gt;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Using ntpd service with shell script and cowsay<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code># Shell Script: .\/believeitornot\n&gt;\/tmp\/sayit\nspeak_the_truth() {\nclear\n cat \/tmp\/sayit | cowsay -f tux\n exit;\n}\n# pgrep -x chronyd&gt;\/dev\/null &amp;&amp; echo -e \"Declaration: Sworn on NTP daemon.\\n\" &gt; \/tmp\/sayit  &amp;&amp; ntpd=1 || ( echo \"Can't trust time without ntpd\" &gt;&gt; \/tmp\/sayit &amp;&amp; speak_the_truth &amp;&amp; exit 1; )\npgrep -x ntpd &gt;\/dev\/null &amp;&amp; echo -e \"Declaration: Sworn on NTP daemon.\\n\" &gt; \/tmp\/sayit  &amp;&amp; ntpd=1 || ( echo \"Can't trust time without ntpd\" &gt;&gt; \/tmp\/sayit &amp;&amp; speak_the_truth &amp;&amp; exit 1; )\nspeak_the_truth\nsleep 1\nif &#91; $ntpd == 1 ]; then\n for day in Saturday Sunday Monday Tuesday Wednesday Thursday; do\n  sleep 1;\n  if &#91; `date +'%A'` != $day ]; then\n   echo -e \"Is this $day: NO. \\n\" &gt;&gt; \/tmp\/sayit\n   speak_the_truth\n  else\n   echo -e \"This is $day, not a Friday.\\n\" &gt;&gt; \/tmp\/sayit\n   speak_the_truth\n   exit;\n  fi\n done;\n  sleep 1;\n  if ! &#91; `date +'%A'` != \"Friday\" ]; then\n   echo -e \"Is this anything but Friday? - NO\\n\" &gt;&gt; \/tmp\/sayit\n   speak_the_truth\n   sleep 1;\n   echo -e \"\\n Thank NTPD it is Friday.\" &gt;&gt; \/tmp\/sayit\n   speak_the_truth\n  fi;\nfi;\n<\/code><\/pre>\n\n\n\n<p>Note that this was done on Cent OS 7. For Cent OS 8 you might not get ntp and instead use chronyd.<\/p>\n\n\n\n<p><strong>Sample Execution and proving of Friday<\/strong> <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>_______________________________\n&lt; Can't trust time without ntpd &gt;\n-------------------------------\n  \\\n   \\\n       .--.\n      |o_o |\n      |:_\/ |\n     \/\/   \\ \\\n    (|     | )\n   \/'\\_   _\/`\\\n   \\___)=(___\/\n\n\n   ___________________________________\n  \/ Declaration: Sworn on NTP daemon. \\\n  |                                   |\n  | Is this Saturday: NO.             |\n  |                                   |\n  | Is this Sunday: NO.               |\n  |                                   |\n  | Is this Monday: NO.               |\n  |                                   |\n  | Is this Tuesday: NO.              |\n  |                                   |\n  | Is this Wednesday: NO.            |\n  |                                   |\n  | Is this Thursday: NO.             |\n  |                                   |\n  | Is this anything but Friday? - NO |\n  |                                   |\n  \\ Thank NTPD it is Friday.          \/\n   -----------------------------------\n         \\\n          \\\n              .--.\n             |o_o |\n             |:_\/ |\n            \/\/   \\ \\\n           (|     | )\n          \/'\\_   _\/`\\\n          \\___)=(___\/\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Stored procedure in MySQL 8 using WITH RECURSIVE<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP PROCEDURE IF EXISTS kedar.is_it_friday;\ndelimiter \/\/\nCREATE PROCEDURE kedar.is_it_friday(IN today varchar(15))\nBEGIN\n\n  IF STR_TO_DATE(today,'%Y-%m-%d') IS NULL THEN\n      SIGNAL SQLSTATE 'ERR0R' SET MESSAGE_TEXT = 'Are you insane?';\n  END IF;\n\n  WITH RECURSIVE `days` AS\n  (\n    SELECT 1 AS `day` UNION ALL SELECT `day` + 1 FROM `days` WHERE `day` &lt; DAY(LAST_DAY(NOW()))\n  )\n  SELECT dt fridays_in_month, if(dt = date(now()),'Hell Yeah!!!','Nope!') is_it_today from (SELECT concat(year(today),'-',lpad(month(today),2,'0'),'-',lpad(day,2,'0')) dt FROM `days` where DAYNAME(concat(year(today),'-',lpad(month(today),2,'0'),'-',lpad(day,2,'0'))) ='FRIDAY') xXx;\nEND\n\/\/\ndelimiter ;<\/code><\/pre>\n\n\n\n<p><strong>Executing the procedure and validating proofs<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt; call kedar.is_it_friday('2022-09-16');\n+------------------+--------------+\n| fridays_in_month | is_it_today  |\n+------------------+--------------+\n| 2022-09-02       | Nope!        |\n| 2022-09-09       | Nope!        |\n| 2022-09-16       | Hell Yeah!!! |\n| 2022-09-23       | Nope!        |\n| 2022-09-30       | Nope!        |\n+------------------+--------------+\n5 rows in set (0.00 sec)<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">List Fridays of the whole year using MySQL procedures<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>\nDROP PROCEDURE IF EXISTS kedar.list_annual_days;\ndelimiter \/\/\nCREATE PROCEDURE kedar.list_annual_days(IN year varchar(4), IN day varchar(10))\nBEGIN\nDECLARE dateStart date;\nDECLARE dateEnd date;\nDECLARE _query VARCHAR(1000);\n\nIF day = '' THEN SET day='FRIDAY'; END IF;\nIF year = '' THEN SET year=year(now()); END IF;\n\nselect day, year;\nset dateStart=(select concat(year,'-01-01'));\nset dateEnd=(select concat(year,'-12-31'));\n\n\nDROP TABLE IF EXISTS days_8582;\nCREATE TEMPORARY TABLE days_8582 (kdt varchar(20), kdy varchar(20));\nWHILE dateStart &lt;= dateEnd DO\n  INSERT INTO days_8582 select dateStart, DAYNAME(dateStart) from dual where  DAYNAME(dateStart) = day;\n  SET dateStart = date_add(dateStart, INTERVAL 1 DAY);\nEND WHILE;\nselect kdt date, kdy day,  if(kdt = date(now()),'Hell Yeah!!!','Nope!') is_it_today,if( datediff(kdt, now()) &lt; 0,concat(abs( datediff(kdt, now())), ' days ago'), concat(abs( datediff(kdt, now())), ' days to go')) `when` from days_8582;\nDROP TABLE IF EXISTS days_8582;\nEND\n\/\/\ndelimiter ;\n<\/code><\/pre>\n\n\n\n<p><strong>Executing the procedure and validating proofs<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql &#91;kedar]&gt; call kedar.list_annual_days('','');\n+--------+------+\n| day    | year |\n+--------+------+\n| FRIDAY | 2022 |\n+--------+------+\n1 row in set (0.001 sec)\n\n+------------+--------+--------------+---------------+\n| date       | day    | is_it_today  | when          |\n+------------+--------+--------------+---------------+\n| 2022-01-07 | Friday | Nope!        | 259 days ago  |\n| 2022-01-14 | Friday | Nope!        | 252 days ago  |\n| 2022-01-21 | Friday | Nope!        | 245 days ago  |\n| 2022-01-28 | Friday | Nope!        | 238 days ago  |\n| 2022-02-04 | Friday | Nope!        | 231 days ago  |\n| 2022-02-11 | Friday | Nope!        | 224 days ago  |\n| 2022-02-18 | Friday | Nope!        | 217 days ago  |\n| 2022-02-25 | Friday | Nope!        | 210 days ago  |\n| 2022-03-04 | Friday | Nope!        | 203 days ago  |\n| 2022-03-11 | Friday | Nope!        | 196 days ago  |\n| 2022-03-18 | Friday | Nope!        | 189 days ago  |\n| 2022-03-25 | Friday | Nope!        | 182 days ago  |\n| 2022-04-01 | Friday | Nope!        | 175 days ago  |\n| 2022-04-08 | Friday | Nope!        | 168 days ago  |\n| 2022-04-15 | Friday | Nope!        | 161 days ago  |\n| 2022-04-22 | Friday | Nope!        | 154 days ago  |\n| 2022-04-29 | Friday | Nope!        | 147 days ago  |\n| 2022-05-06 | Friday | Nope!        | 140 days ago  |\n| 2022-05-13 | Friday | Nope!        | 133 days ago  |\n| 2022-05-20 | Friday | Nope!        | 126 days ago  |\n| 2022-05-27 | Friday | Nope!        | 119 days ago  |\n| 2022-06-03 | Friday | Nope!        | 112 days ago  |\n| 2022-06-10 | Friday | Nope!        | 105 days ago  |\n| 2022-06-17 | Friday | Nope!        | 98 days ago   |\n| 2022-06-24 | Friday | Nope!        | 91 days ago   |\n| 2022-07-01 | Friday | Nope!        | 84 days ago   |\n| 2022-07-08 | Friday | Nope!        | 77 days ago   |\n| 2022-07-15 | Friday | Nope!        | 70 days ago   |\n| 2022-07-22 | Friday | Nope!        | 63 days ago   |\n| 2022-07-29 | Friday | Nope!        | 56 days ago   |\n| 2022-08-05 | Friday | Nope!        | 49 days ago   |\n| 2022-08-12 | Friday | Nope!        | 42 days ago   |\n| 2022-08-19 | Friday | Nope!        | 35 days ago   |\n| 2022-08-26 | Friday | Nope!        | 28 days ago   |\n| 2022-09-02 | Friday | Nope!        | 21 days ago   |\n| 2022-09-09 | Friday | Nope!        | 14 days ago   |\n| 2022-09-16 | Friday | Nope!        | 7 days ago    |\n<strong>| 2022-09-23 | Friday | Hell Yeah!!! | 0 days to go  |<\/strong>\n| 2022-09-30 | Friday | Nope!        | 7 days to go  |\n| 2022-10-07 | Friday | Nope!        | 14 days to go |\n| 2022-10-14 | Friday | Nope!        | 21 days to go |\n| 2022-10-21 | Friday | Nope!        | 28 days to go |\n| 2022-10-28 | Friday | Nope!        | 35 days to go |\n| 2022-11-04 | Friday | Nope!        | 42 days to go |\n| 2022-11-11 | Friday | Nope!        | 49 days to go |\n| 2022-11-18 | Friday | Nope!        | 56 days to go |\n| 2022-11-25 | Friday | Nope!        | 63 days to go |\n| 2022-12-02 | Friday | Nope!        | 70 days to go |\n| 2022-12-09 | Friday | Nope!        | 77 days to go |\n| 2022-12-16 | Friday | Nope!        | 84 days to go |\n| 2022-12-23 | Friday | Nope!        | 91 days to go |\n| 2022-12-30 | Friday | Nope!        | 98 days to go |\n+------------+--------+--------------+---------------+\n52 rows in set (0.020 sec)<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Let&#8217;s verifying against all time-zones and verify all are having Friday<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>&#91;kedar@nitty-witty.com ~]# for tz in `timedatectl list-timezones`; do echo $tz has `date --date='TZ=\"$tz\" this Fri' +'%A'`; done<\/strong>\nAfrica\/Abidjan has Friday\nAfrica\/Accra has Friday\nAfrica\/Addis_Ababa has Friday\nAfrica\/Algiers has Friday\nAfrica\/Asmara has Friday\nAfrica\/Bamako has Friday\nAfrica\/Bangui has Friday\nAfrica\/Banjul has Friday\nAfrica\/Bissau has Friday\nAfrica\/Blantyre has Friday\nAfrica\/Brazzaville has Friday\nAfrica\/Bujumbura has Friday\nAfrica\/Cairo has Friday\nAfrica\/Casablanca has Friday\nAfrica\/Ceuta has Friday\nAfrica\/Conakry has Friday\nAfrica\/Dakar has Friday\nAfrica\/Dar_es_Salaam has Friday\nAfrica\/Djibouti has Friday\nAfrica\/Douala has Friday\nAfrica\/El_Aaiun has Friday\nAfrica\/Freetown has Friday\nAfrica\/Gaborone has Friday\nAfrica\/Harare has Friday\nAfrica\/Johannesburg has Friday\nAfrica\/Juba has Friday\nAfrica\/Kampala has Friday\nAfrica\/Khartoum has Friday\nAfrica\/Kigali has Friday\nAfrica\/Kinshasa has Friday\nAfrica\/Lagos has Friday\nAfrica\/Libreville has Friday\nAfrica\/Lome has Friday\nAfrica\/Luanda has Friday\nAfrica\/Lubumbashi has Friday\nAfrica\/Lusaka has Friday\nAfrica\/Malabo has Friday\nAfrica\/Maputo has Friday\nAfrica\/Maseru has Friday\nAfrica\/Mbabane has Friday\nAfrica\/Mogadishu has Friday\nAfrica\/Monrovia has Friday\nAfrica\/Nairobi has Friday\nAfrica\/Ndjamena has Friday\nAfrica\/Niamey has Friday\nAfrica\/Nouakchott has Friday\nAfrica\/Ouagadougou has Friday\nAfrica\/Porto-Novo has Friday\nAfrica\/Sao_Tome has Friday\nAfrica\/Tripoli has Friday\nAfrica\/Tunis has Friday\nAfrica\/Windhoek has Friday\nAmerica\/Adak has Friday\nAmerica\/Anchorage has Friday\nAmerica\/Anguilla has Friday\nAmerica\/Antigua has Friday\nAmerica\/Araguaina has Friday\nAmerica\/Argentina\/Buenos_Aires has Friday\nAmerica\/Argentina\/Catamarca has Friday\nAmerica\/Argentina\/Cordoba has Friday\nAmerica\/Argentina\/Jujuy has Friday\nAmerica\/Argentina\/La_Rioja has Friday\nAmerica\/Argentina\/Mendoza has Friday\nAmerica\/Argentina\/Rio_Gallegos has Friday\nAmerica\/Argentina\/Salta has Friday\nAmerica\/Argentina\/San_Juan has Friday\nAmerica\/Argentina\/San_Luis has Friday\nAmerica\/Argentina\/Tucuman has Friday\nAmerica\/Argentina\/Ushuaia has Friday\nAmerica\/Aruba has Friday\nAmerica\/Asuncion has Friday\nAmerica\/Atikokan has Friday\nAmerica\/Bahia has Friday\nAmerica\/Bahia_Banderas has Friday\nAmerica\/Barbados has Friday\nAmerica\/Belem has Friday\nAmerica\/Belize has Friday\nAmerica\/Blanc-Sablon has Friday\nAmerica\/Boa_Vista has Friday\nAmerica\/Bogota has Friday\nAmerica\/Boise has Friday\nAmerica\/Cambridge_Bay has Friday\nAmerica\/Campo_Grande has Friday\nAmerica\/Cancun has Friday\nAmerica\/Caracas has Friday\nAmerica\/Cayenne has Friday\nAmerica\/Cayman has Friday\nAmerica\/Chicago has Friday\nAmerica\/Chihuahua has Friday\nAmerica\/Costa_Rica has Friday\nAmerica\/Creston has Friday\nAmerica\/Cuiaba has Friday\nAmerica\/Curacao has Friday\nAmerica\/Danmarkshavn has Friday\nAmerica\/Dawson has Friday\nAmerica\/Dawson_Creek has Friday\nAmerica\/Denver has Friday\nAmerica\/Detroit has Friday\nAmerica\/Dominica has Friday\nAmerica\/Edmonton has Friday\nAmerica\/Eirunepe has Friday\nAmerica\/El_Salvador has Friday\nAmerica\/Fort_Nelson has Friday\nAmerica\/Fortaleza has Friday\nAmerica\/Glace_Bay has Friday\nAmerica\/Goose_Bay has Friday\nAmerica\/Grand_Turk has Friday\nAmerica\/Grenada has Friday\nAmerica\/Guadeloupe has Friday\nAmerica\/Guatemala has Friday\nAmerica\/Guayaquil has Friday\nAmerica\/Guyana has Friday\nAmerica\/Halifax has Friday\nAmerica\/Havana has Friday\nAmerica\/Hermosillo has Friday\nAmerica\/Indiana\/Indianapolis has Friday\nAmerica\/Indiana\/Knox has Friday\nAmerica\/Indiana\/Marengo has Friday\nAmerica\/Indiana\/Petersburg has Friday\nAmerica\/Indiana\/Tell_City has Friday\nAmerica\/Indiana\/Vevay has Friday\nAmerica\/Indiana\/Vincennes has Friday\nAmerica\/Indiana\/Winamac has Friday\nAmerica\/Inuvik has Friday\nAmerica\/Iqaluit has Friday\nAmerica\/Jamaica has Friday\nAmerica\/Juneau has Friday\nAmerica\/Kentucky\/Louisville has Friday\nAmerica\/Kentucky\/Monticello has Friday\nAmerica\/Kralendijk has Friday\nAmerica\/La_Paz has Friday\nAmerica\/Lima has Friday\nAmerica\/Los_Angeles has Friday\nAmerica\/Lower_Princes has Friday\nAmerica\/Maceio has Friday\nAmerica\/Managua has Friday\nAmerica\/Manaus has Friday\nAmerica\/Marigot has Friday\nAmerica\/Martinique has Friday\nAmerica\/Matamoros has Friday\nAmerica\/Mazatlan has Friday\nAmerica\/Menominee has Friday\nAmerica\/Merida has Friday\nAmerica\/Metlakatla has Friday\nAmerica\/Mexico_City has Friday\nAmerica\/Miquelon has Friday\nAmerica\/Moncton has Friday\nAmerica\/Monterrey has Friday\nAmerica\/Montevideo has Friday\nAmerica\/Montserrat has Friday\nAmerica\/Nassau has Friday\nAmerica\/New_York has Friday\nAmerica\/Nipigon has Friday\nAmerica\/Nome has Friday\nAmerica\/Noronha has Friday\nAmerica\/North_Dakota\/Beulah has Friday\nAmerica\/North_Dakota\/Center has Friday\nAmerica\/North_Dakota\/New_Salem has Friday\nAmerica\/Nuuk has Friday\nAmerica\/Ojinaga has Friday\nAmerica\/Panama has Friday\nAmerica\/Pangnirtung has Friday\nAmerica\/Paramaribo has Friday\nAmerica\/Phoenix has Friday\nAmerica\/Port-au-Prince has Friday\nAmerica\/Port_of_Spain has Friday\nAmerica\/Porto_Velho has Friday\nAmerica\/Puerto_Rico has Friday\nAmerica\/Punta_Arenas has Friday\nAmerica\/Rainy_River has Friday\nAmerica\/Rankin_Inlet has Friday\nAmerica\/Recife has Friday\nAmerica\/Regina has Friday\nAmerica\/Resolute has Friday\nAmerica\/Rio_Branco has Friday\nAmerica\/Santarem has Friday\nAmerica\/Santiago has Friday\nAmerica\/Santo_Domingo has Friday\nAmerica\/Sao_Paulo has Friday\nAmerica\/Scoresbysund has Friday\nAmerica\/Sitka has Friday\nAmerica\/St_Barthelemy has Friday\nAmerica\/St_Johns has Friday\nAmerica\/St_Kitts has Friday\nAmerica\/St_Lucia has Friday\nAmerica\/St_Thomas has Friday\nAmerica\/St_Vincent has Friday\nAmerica\/Swift_Current has Friday\nAmerica\/Tegucigalpa has Friday\nAmerica\/Thule has Friday\nAmerica\/Thunder_Bay has Friday\nAmerica\/Tijuana has Friday\nAmerica\/Toronto has Friday\nAmerica\/Tortola has Friday\nAmerica\/Vancouver has Friday\nAmerica\/Whitehorse has Friday\nAmerica\/Winnipeg has Friday\nAmerica\/Yakutat has Friday\nAmerica\/Yellowknife has Friday\nAntarctica\/Casey has Friday\nAntarctica\/Davis has Friday\nAntarctica\/DumontDUrville has Friday\nAntarctica\/Macquarie has Friday\nAntarctica\/Mawson has Friday\nAntarctica\/McMurdo has Friday\nAntarctica\/Palmer has Friday\nAntarctica\/Rothera has Friday\nAntarctica\/Syowa has Friday\nAntarctica\/Troll has Friday\nAntarctica\/Vostok has Friday\nArctic\/Longyearbyen has Friday\nAsia\/Aden has Friday\nAsia\/Almaty has Friday\nAsia\/Amman has Friday\nAsia\/Anadyr has Friday\nAsia\/Aqtau has Friday\nAsia\/Aqtobe has Friday\nAsia\/Ashgabat has Friday\nAsia\/Atyrau has Friday\nAsia\/Baghdad has Friday\nAsia\/Bahrain has Friday\nAsia\/Baku has Friday\nAsia\/Bangkok has Friday\nAsia\/Barnaul has Friday\nAsia\/Beirut has Friday\nAsia\/Bishkek has Friday\nAsia\/Brunei has Friday\nAsia\/Chita has Friday\nAsia\/Choibalsan has Friday\nAsia\/Colombo has Friday\nAsia\/Damascus has Friday\nAsia\/Dhaka has Friday\nAsia\/Dili has Friday\nAsia\/Dubai has Friday\nAsia\/Dushanbe has Friday\nAsia\/Famagusta has Friday\nAsia\/Gaza has Friday\nAsia\/Hebron has Friday\nAsia\/Ho_Chi_Minh has Friday\nAsia\/Hong_Kong has Friday\nAsia\/Hovd has Friday\nAsia\/Irkutsk has Friday\nAsia\/Jakarta has Friday\nAsia\/Jayapura has Friday\nAsia\/Jerusalem has Friday\nAsia\/Kabul has Friday\nAsia\/Kamchatka has Friday\nAsia\/Karachi has Friday\nAsia\/Kathmandu has Friday\nAsia\/Khandyga has Friday\nAsia\/Kolkata has Friday\nAsia\/Krasnoyarsk has Friday\nAsia\/Kuala_Lumpur has Friday\nAsia\/Kuching has Friday\nAsia\/Kuwait has Friday\nAsia\/Macau has Friday\nAsia\/Magadan has Friday\nAsia\/Makassar has Friday\nAsia\/Manila has Friday\nAsia\/Muscat has Friday\nAsia\/Nicosia has Friday\nAsia\/Novokuznetsk has Friday\nAsia\/Novosibirsk has Friday\nAsia\/Omsk has Friday\nAsia\/Oral has Friday\nAsia\/Phnom_Penh has Friday\nAsia\/Pontianak has Friday\nAsia\/Pyongyang has Friday\nAsia\/Qatar has Friday\nAsia\/Qostanay has Friday\nAsia\/Qyzylorda has Friday\nAsia\/Riyadh has Friday\nAsia\/Sakhalin has Friday\nAsia\/Samarkand has Friday\nAsia\/Seoul has Friday\nAsia\/Shanghai has Friday\nAsia\/Singapore has Friday\nAsia\/Srednekolymsk has Friday\nAsia\/Taipei has Friday\nAsia\/Tashkent has Friday\nAsia\/Tbilisi has Friday\nAsia\/Tehran has Friday\nAsia\/Thimphu has Friday\nAsia\/Tokyo has Friday\nAsia\/Tomsk has Friday\nAsia\/Ulaanbaatar has Friday\nAsia\/Urumqi has Friday\nAsia\/Ust-Nera has Friday\nAsia\/Vientiane has Friday\nAsia\/Vladivostok has Friday\nAsia\/Yakutsk has Friday\nAsia\/Yangon has Friday\nAsia\/Yekaterinburg has Friday\nAsia\/Yerevan has Friday\nAtlantic\/Azores has Friday\nAtlantic\/Bermuda has Friday\nAtlantic\/Canary has Friday\nAtlantic\/Cape_Verde has Friday\nAtlantic\/Faroe has Friday\nAtlantic\/Madeira has Friday\nAtlantic\/Reykjavik has Friday\nAtlantic\/South_Georgia has Friday\nAtlantic\/St_Helena has Friday\nAtlantic\/Stanley has Friday\nAustralia\/Adelaide has Friday\nAustralia\/Brisbane has Friday\nAustralia\/Broken_Hill has Friday\nAustralia\/Darwin has Friday\nAustralia\/Eucla has Friday\nAustralia\/Hobart has Friday\nAustralia\/Lindeman has Friday\nAustralia\/Lord_Howe has Friday\nAustralia\/Melbourne has Friday\nAustralia\/Perth has Friday\nAustralia\/Sydney has Friday\nEurope\/Amsterdam has Friday\nEurope\/Andorra has Friday\nEurope\/Astrakhan has Friday\nEurope\/Athens has Friday\nEurope\/Belgrade has Friday\nEurope\/Berlin has Friday\nEurope\/Bratislava has Friday\nEurope\/Brussels has Friday\nEurope\/Bucharest has Friday\nEurope\/Budapest has Friday\nEurope\/Busingen has Friday\nEurope\/Chisinau has Friday\nEurope\/Copenhagen has Friday\nEurope\/Dublin has Friday\nEurope\/Gibraltar has Friday\nEurope\/Guernsey has Friday\nEurope\/Helsinki has Friday\nEurope\/Isle_of_Man has Friday\nEurope\/Istanbul has Friday\nEurope\/Jersey has Friday\nEurope\/Kaliningrad has Friday\nEurope\/Kiev has Friday\nEurope\/Kirov has Friday\nEurope\/Lisbon has Friday\nEurope\/Ljubljana has Friday\nEurope\/London has Friday\nEurope\/Luxembourg has Friday\nEurope\/Madrid has Friday\nEurope\/Malta has Friday\nEurope\/Mariehamn has Friday\nEurope\/Minsk has Friday\nEurope\/Monaco has Friday\nEurope\/Moscow has Friday\nEurope\/Oslo has Friday\nEurope\/Paris has Friday\nEurope\/Podgorica has Friday\nEurope\/Prague has Friday\nEurope\/Riga has Friday\nEurope\/Rome has Friday\nEurope\/Samara has Friday\nEurope\/San_Marino has Friday\nEurope\/Sarajevo has Friday\nEurope\/Saratov has Friday\nEurope\/Simferopol has Friday\nEurope\/Skopje has Friday\nEurope\/Sofia has Friday\nEurope\/Stockholm has Friday\nEurope\/Tallinn has Friday\nEurope\/Tirane has Friday\nEurope\/Ulyanovsk has Friday\nEurope\/Uzhgorod has Friday\nEurope\/Vaduz has Friday\nEurope\/Vatican has Friday\nEurope\/Vienna has Friday\nEurope\/Vilnius has Friday\nEurope\/Volgograd has Friday\nEurope\/Warsaw has Friday\nEurope\/Zagreb has Friday\nEurope\/Zaporozhye has Friday\nEurope\/Zurich has Friday\nIndian\/Antananarivo has Friday\nIndian\/Chagos has Friday\nIndian\/Christmas has Friday\nIndian\/Cocos has Friday\nIndian\/Comoro has Friday\nIndian\/Kerguelen has Friday\nIndian\/Mahe has Friday\nIndian\/Maldives has Friday\nIndian\/Mauritius has Friday\nIndian\/Mayotte has Friday\nIndian\/Reunion has Friday\nPacific\/Apia has Friday\nPacific\/Auckland has Friday\nPacific\/Bougainville has Friday\nPacific\/Chatham has Friday\nPacific\/Chuuk has Friday\nPacific\/Easter has Friday\nPacific\/Efate has Friday\nPacific\/Fakaofo has Friday\nPacific\/Fiji has Friday\nPacific\/Funafuti has Friday\nPacific\/Galapagos has Friday\nPacific\/Gambier has Friday\nPacific\/Guadalcanal has Friday\nPacific\/Guam has Friday\nPacific\/Honolulu has Friday\nPacific\/Kanton has Friday\nPacific\/Kiritimati has Friday\nPacific\/Kosrae has Friday\nPacific\/Kwajalein has Friday\nPacific\/Majuro has Friday\nPacific\/Marquesas has Friday\nPacific\/Midway has Friday\nPacific\/Nauru has Friday\nPacific\/Niue has Friday\nPacific\/Norfolk has Friday\nPacific\/Noumea has Friday\nPacific\/Pago_Pago has Friday\nPacific\/Palau has Friday\nPacific\/Pitcairn has Friday\nPacific\/Pohnpei has Friday\nPacific\/Port_Moresby has Friday\nPacific\/Rarotonga has Friday\nPacific\/Saipan has Friday\nPacific\/Tahiti has Friday\nPacific\/Tarawa has Friday\nPacific\/Tongatapu has Friday\nPacific\/Wake has Friday\nPacific\/Wallis has Friday\nUTC has Friday\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Verifying from cron<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;root@ip-172-31-87-173 ~]# crontab -l\n* * * * FRI echo \"Damn right it is Friday.\" &gt; can_you_believe_it\n0 0 * * SAT rm -f can_you_believe_it\n&#91;root@ip-172-31-87-173 ~]# cat can_you_believe_it\nDamn right it is Friday.\n&#91;root@ip-172-31-87-173 ~]#\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Verifying from a website<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;kedar@nitty-witty.com ~]$ curl -s -I  kedar.vaijanapurkar.in | grep date | cut -c7-9\nFri\n<\/code><\/pre>\n\n\n\n<p>I&#8217;m open to more ideas as you know, doubters gonna doubt.<\/p>\n","protected":false},"excerpt":{"rendered":"In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a &#8220;Friday&#8221;, so much so that they cannot believe&hellip;\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[4,8,377,378],"tags":[504,591,43,427,505,108,590,506],"class_list":{"0":"post-2612","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-just-for-fun","7":"category-mysql","8":"category-mysql-articles","9":"category-mysql-scripts-mysql","10":"tag-friday","11":"tag-friday-proof","12":"tag-fun","13":"tag-mysql","14":"tag-mysql8","15":"tag-stored-procedure","16":"tag-tgif","17":"tag-with-recusive"},"aioseo_notices":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/2612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/comments?post=2612"}],"version-history":[{"count":5,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/2612\/revisions"}],"predecessor-version":[{"id":2905,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/2612\/revisions\/2905"}],"wp:attachment":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/media?parent=2612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/categories?post=2612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/tags?post=2612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}