{"id":6528,"date":"2022-02-07T07:00:00","date_gmt":"2022-02-07T01:30:00","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=6528"},"modified":"2022-09-21T15:51:23","modified_gmt":"2022-09-21T10:21:23","slug":"mysql-date-time-function","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-date-time-function\/","title":{"rendered":"MySQL Date Time Function"},"content":{"rendered":"\n<p>MySQL Date Time \u0915\u0947 \u0915\u0941\u091b Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0907\u0938 Article \u092e\u0947 \u092c\u0924\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 \u0915\u0941\u091b Date \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 Function \u0939\u0948\u0902 \u0915\u0941\u091b Function Time \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 , \u0915\u0941\u091b Date Time \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u0914\u0930 \u0915\u0941\u091b Function Conversion \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u0939\u0948 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>MySQL Date Related Function<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL CURDATE() : Current Date <\/li><li>MAKEDATE(Year, No of Days) : Make Date From Year &amp; No of Day <\/li><li>DAYNAME(Date) : Find Day Name (Sunday to Saturday) <\/li><li>MySQL MONTH(Date) : Find Month Index (1 to 12)<\/li><li>MONTHNAME(Date) : Find Month Name (January to December)<\/li><li>MySQL LAST_DAY(Date) : Find Month Last Date (28, 29,30,31)<\/li><li>MySQL YEAR (Date) : Find Year Using Date<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>MySQL Time Related Function<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL CURTIME() : Find Current Time<\/li><li>MAKETIME (Hour, Minute, Second) : Make Time Using Hour, Minute, Second)<\/li><li>HOUR \/ MINUTE \/ SECOND \/ MICROSECOND from Date<\/li><li>MySQL TIME_TO_SEC(Time) : Convert TIME TO SECOND<\/li><li>MySQL SEC_TO_TIME(Seconds) : Convert SECOND to TIME Format<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>MySQL Other Function<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL ADDDATE(Date, Days) : No of Days add on Given Date<\/li><li>DATE_ADD (Date, Interval Number Unit) : Add Day\/Week\/Month\/Year<\/li><li>DATE_SUB (Date, Interval Number Unit) : Substract Day\/Week\/Month\/Year<\/li><li>DATEDIFF(Date1, Date2) : Find Date Difference Between Two Dates<\/li><li>MySQL DATE (DateTime) : Find Date From Date Time<\/li><li>MySQL TIME (DateTime) : Find Time From Date Time<\/li><li>MySQL NOW() : Get Current Date &amp; Time<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"CURDATE\">MySQL CURDATE() : Current Date<\/h2>\n\n\n\n<p>MySQL CURDATE() Function \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0939\u092e Current Date \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT CURDATE()<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"96\" height=\"41\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-73.png?resize=96%2C41&#038;ssl=1\" alt=\"\" class=\"wp-image-6529\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"MAKEDATE\">MAKEDATE(Year, No of Days) : Make Date From Year &amp; No of Day<\/h2>\n\n\n\n<p>Year \u0914\u0930 No of Day \u0938\u0947 Date \u092c\u0928\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e MakeDate \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT MAKEDATE(2022,05), MAKEDATE(2022,31), MAKEDATE(2022,33);<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"445\" height=\"41\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-74.png?resize=445%2C41&#038;ssl=1\" alt=\"MySQL MAKEDATE FUNCTION\" class=\"wp-image-6531\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-74.png?w=445&amp;ssl=1 445w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-74.png?resize=300%2C28&amp;ssl=1 300w\" sizes=\"auto, (max-width: 445px) 100vw, 445px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"DAYNAME\">DAYNAME(Date) : Find Day Name (Sunday to Saturday)<\/h2>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u092d\u0940 Date \u0938\u0947 Sunday to Saturday \u092f\u093e\u0928\u093f \u0915\u0940 \u0935\u093e\u0930 \u092a\u0924\u093e \u0932\u0917\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e MySQL Dayname Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT DAYNAME('2022-01-22')<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"176\" height=\"38\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-75.png?resize=176%2C38&#038;ssl=1\" alt=\"MySQL DAYNAME FUNCTION\" class=\"wp-image-6534\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"MONTH\">MySQL MONTH(Date) : Find Month Index (1 to 12)<\/h2>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u092d\u0940 Date \u092e\u0947 \u0938\u0947 Month Find \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f MySQL Month \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0907\u0938 Function \u0938\u0947 1 \u0938\u0947 \u0932\u0947\u0915\u0930 12 \u0924\u0915 \u092e\u0947 \u0938\u0947 \u0915\u094b\u0908 month Return \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT MONTH('2022-01-22')<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"152\" height=\"43\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-76.png?resize=152%2C43&#038;ssl=1\" alt=\"MySQL MONTH FUNCTION\" class=\"wp-image-6536\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-76.png?w=152&amp;ssl=1 152w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-76.png?resize=150%2C43&amp;ssl=1 150w\" sizes=\"auto, (max-width: 152px) 100vw, 152px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"MONTHNAME\">MONTHNAME(Date) : Find Month Name (January to December)<\/h2>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u092d\u0940 Date \u0938\u0947 \u0906\u092a\u0915\u0947 \u092f\u0926\u093f \u0909\u0938 Month \u0915\u093e \u0928\u093e\u092e Find \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0906\u092a MonthName Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0907\u0938 Function \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e January \u0938\u0947 December \u0924\u0915 \u0915\u0940 value Return \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT MONTHNAME('2022-01-22')<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"200\" height=\"40\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-77.png?resize=200%2C40&#038;ssl=1\" alt=\"MySQL MONTHNAME FUNCTION\" class=\"wp-image-6538\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"LAST_DAY\">MySQL LAST_DAY(Date) : Find Month Last Date (28, 29,30,31)<\/h2>\n\n\n\n<p>\u0926\u0940 \u0917\u0908 Date \u0938\u0947 \u0909\u0938 Month \u0915\u0947 \u0905\u0902\u0924\u093f\u092e \u0926\u093f\u0928\u093e\u0902\u0915 Find \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f MySQL  LAST_DAY  \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT LAST_DAY('2022-02-01'), LAST_DAY('2024-02-01')<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"337\" height=\"39\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-78.png?resize=337%2C39&#038;ssl=1\" alt=\"MySQL LAST_DAY FUNCTION\" class=\"wp-image-6540\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-78.png?w=337&amp;ssl=1 337w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-78.png?resize=300%2C35&amp;ssl=1 300w\" sizes=\"auto, (max-width: 337px) 100vw, 337px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"YEAR\">MySQL YEAR (Date) : Find Year Using Date<\/h2>\n\n\n\n<p>\u0926\u0940 \u0917\u0908 \u0926\u093f\u0928\u093e\u0902\u0915 \u092e\u0947 \u0938\u0947 Year Find \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e MySQL Year Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT YEAR('2022-02-01');<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"139\" height=\"38\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-79.png?resize=139%2C38&#038;ssl=1\" alt=\"MySQL YEAR FUNCTION\" class=\"wp-image-6546\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"CURTIME\">MySQL CURTIME() : Find Current Time <\/h2>\n\n\n\n<p>Current Time \u091c\u094d\u091e\u093e\u0924 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e CURTIME \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT CURTIME();<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"90\" height=\"36\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-80.png?resize=90%2C36&#038;ssl=1\" alt=\"MySQL CURTIME FUNCTION\" class=\"wp-image-6549\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"MAKETIME\">MAKETIME (Hour, Minute, Second) : Make Time Using Hour, Minute, Second)<\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 Hour Minute Second \u0915\u094b \u091c\u094b\u095c\u0915\u0930 Time Format \u092c\u0928\u093e\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e MAKETIME \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT MAKETIME(02,20,15)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"152\" height=\"38\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-81.png?resize=152%2C38&#038;ssl=1\" alt=\"MySQL MAKETIME FUNCTION\" class=\"wp-image-6550\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-81.png?w=152&amp;ssl=1 152w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-81.png?resize=150%2C38&amp;ssl=1 150w\" sizes=\"auto, (max-width: 152px) 100vw, 152px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"HOUR\">HOUR \/  MINUTE \/  SECOND \/  MICROSECOND  from Date<\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 \u092d\u0940 Time \u092e\u0947 \u0938\u0947 Hour , Minute, Second, Microsecond \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0947 \u0907\u0928 Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964   <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">select HOUR('02:20:15.25'), \nMINUTE('02:20:15.25'), \nSECOND('02:20:15.25'), \nMICROSECOND('02:20:15.25');<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"39\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-82.png?resize=640%2C39&#038;ssl=1\" alt=\"MySQL HOUR MINUTE SECOND MICROSECOND FUNCTION\" class=\"wp-image-6552\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-82.png?w=661&amp;ssl=1 661w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-82.png?resize=300%2C18&amp;ssl=1 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u0939\u092e-\u0930-\u0905\u0928-\u092f-\u0906\u0930-\u091f-\u0915\u0932\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>\u00a0<\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"TIME_TO_SEC\">MySQL TIME_TO_SEC(Time) : Convert TIME TO SECOND <\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 Time Format \u0938\u0947 No of Second Find \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e\u0947 Time to Sec Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT TIME_TO_SEC('02:23:15')<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"180\" height=\"38\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-83.png?resize=180%2C38&#038;ssl=1\" alt=\"MySQL TIME_TO_SEC FUNCTION\" class=\"wp-image-6554\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"265\" height=\"115\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-84.png?resize=265%2C115&#038;ssl=1\" alt=\"MySQL TIME to Second Conversion FUNCTION\" class=\"wp-image-6555\"\/><\/figure>\n\n\n\n<p>\u092f\u0939\u093e\u0901 \u092a\u0930 2 Hours \u0915\u094b Second \u092e\u0947 Change \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0926\u094b \u092a\u0930 60 \u0938\u0947 \u0917\u0941\u0923\u093e \u0915\u093f\u092f\u093e \u0939\u0948\u0902 (2 X 60  X 60) \u0924\u092c 7200 Second \u0939\u094b\u0902\u0917\u0947 \u0964 <\/p>\n\n\n\n<p>\u0909\u0938\u0915\u0947 \u092c\u093e\u0926 23 Minute \u0915\u094b Second \u092e\u0947 Change \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f (23 X 60) \u0924\u092c 1380 Second \u0939\u094b\u0902\u0917\u0947 \u0964 <\/p>\n\n\n\n<p>\u0905\u092c \u0905\u0902\u0924 \u092e\u0947 7200 + 1380 + 15 \u0915\u094b \u091c\u094b\u095c\u0947\u0902\u0917\u0947 \u0924\u094b \u0915\u0941\u0932 8595 \u0906\u090f\u0917\u093e \u0964 <\/p>\n\n\n\n<p>\u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 Time \u0938\u0947 Second \u092e\u0947 \u092a\u0930\u093f\u0935\u0930\u094d\u0924\u0928 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964  <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"SEC_TO_TIME\">MySQL SEC_TO_TIME(Seconds) : Convert SECOND to TIME Format<\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0939\u092e\u0947 Seconds \u0915\u094b Time Format \u092e\u0947 \u092c\u0926\u0932\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e  SEC_TO_TIME \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT SEC_TO_TIME(8595)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"42\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-85.png?resize=150%2C42&#038;ssl=1\" alt=\"\" class=\"wp-image-6557\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"519\" height=\"76\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-86.png?resize=519%2C76&#038;ssl=1\" alt=\"MySQL Second to Time Convertion FUNCTION\" class=\"wp-image-6558\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-86.png?w=519&amp;ssl=1 519w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-86.png?resize=300%2C44&amp;ssl=1 300w\" sizes=\"auto, (max-width: 519px) 100vw, 519px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>\u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 8595 \u0938\u0947\u0915\u0902\u0921 \u0939\u0948\u0902 \u0907\u0938\u092e\u0947 \u0938\u0947 \u0939\u092e \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 Hour Find  \u0915\u0930\u0947\u0902\u0917\u0947, \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 Minute \u0913\u0930 \u0905\u0902\u0924 \u092e\u0947 \u091c\u094b \u0936\u0947\u0937 \u0939\u0948\u0902 \u0935\u0939 \u0938\u0947\u0915\u0902\u0921 \u0939\u094b\u0902\u0917\u0947 \u0964 <\/li><li>Hour Find \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f 8595 \u0915\u094b 3600 (60 X 60) \u0938\u0947 \u092d\u093e\u0917 \u0932\u0917\u093e\u090f\u0902\u0917\u0947 \u0924\u092c 2.3875 \u0906\u090f\u0917\u093e \u0907\u0938\u092e\u0947 \u0938\u0947 \u092a\u0949\u0907\u0902\u091f \u0915\u0947 \u092a\u0939\u0932\u0947 \u0915\u0940 \u0938\u0916\u094d\u092f\u093e \u0938\u0947 Complete Hours \u092c\u0928\u093e \u0932\u0947\u0902\u0917\u0947 , \u092f\u093e\u0928\u093f \u0915\u0940 2 \u0918\u0902\u091f\u0947 \u0964 \u0905\u092c 2 \u0918\u0902\u091f\u0947 \u0915\u094b \u0938\u0947\u0915\u0902\u0921 \u092e\u0947 \u092c\u0926\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f 2 x 60 x 60 \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b 7200 \u0906\u090f\u0917\u093e \u0964 <\/li><li>\u0905\u092c \u0915\u0941\u0932 8595 \u092e\u0947 \u0938\u0947 7200 \u0918\u093e\u091f\u093e \u0926\u0947\u0902\u0917\u0947 \u0924\u094b 1395 Second \u092c\u091a\u0947\u0902\u0917\u0947 \u0907\u0938\u092e\u0947 \u0938\u0947 \u0939\u092e\u0947 Minute \u092c\u0928\u093e\u0928\u093e \u0939\u094b\u0902\u0917\u0947 \u0964 <\/li><li>\u0905\u092c 1395 \u0915\u094b 60 \u0938\u0947 \u092d\u093e\u0917 \u0926\u0947\u0902\u0917\u0947 \u0924\u094b 23.25 \u0906\u090f\u0917\u093e \u0924\u094b \u0907\u0938\u092e\u0947 \u0938\u0947 23 \u092e\u093f\u0928\u091f \u0905\u0932\u0917 \u0915\u0930 \u0932\u0947\u0902\u0917\u0947 , \u0905\u092c 23 x 60 \u092f\u093e\u0928\u093f 1380 \u0938\u0947\u0915\u0902\u0921 \u0939\u094b\u0902\u0917\u0947 \u0964 <\/li><li>\u0905\u092c 1380 \u0915\u094b 1395 \u092e\u0947 \u0938\u0947 \u0918\u091f\u093e \u0926\u0947\u0902\u0917\u0947 \u0924\u094b \u092c\u091a\u0947 \u0939\u0941\u090f 15 \u0938\u0947\u0915\u0902\u0921  \u0939\u094b\u0902\u0917\u0947 \u0964 <\/li><li>\u0907\u0938 \u0905\u0928\u0941\u0938\u093e\u0930 \u0915\u0941\u0932 2 Hours, 23 Minute \u0914\u0930 15 \u0938\u0947\u0915\u0902\u0921 \u0906\u090f\u0902\u0917\u0947 \u0964 <\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"ADDDATE\">MySQL ADDDATE(Date, Days) : No of Days add on Given Date<\/h2>\n\n\n\n<p>\u091c\u092c \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 Date \u092e\u0947 \u0926\u093f\u0928 \u091c\u094b\u095c\u0915\u0930 \u090f\u0915 \u0928\u0908 Date \u092c\u0928\u093e\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e AddDate Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964 \u092f\u0926\u093f \u0939\u092e \u0926\u093f\u0928\u094b\u0902 \u0915\u0940 \u0938\u0902\u0916\u094d\u092f\u093e \u0915\u094b Negative \u0915\u0930 \u0926\u0947\u0902\u0917\u0947 \u0924\u094b \u092f\u0939 \u092a\u0939\u0932\u0947 \u0915\u0940 \u0926\u093f\u0928\u093e\u0902\u0915 Return \u0915\u0930 \u0926\u0947\u0917\u093e \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT ADDDATE('2022-03-02', 31), ADDDATE('2022-03-02', -5)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"378\" height=\"41\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-94.png?resize=378%2C41&#038;ssl=1\" alt=\"MySQL ADDDATE FUNCTION\" class=\"wp-image-6618\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-94.png?w=378&amp;ssl=1 378w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-94.png?resize=300%2C33&amp;ssl=1 300w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">DATE_ADD (Date, Interval Number Unit) : Add Day\/Week\/Month\/Year <\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 Date \u092e\u0947 \u0915\u094b\u0908 Number \u091c\u094b\u095c \u0915\u0930 \u0906\u0917\u0947 \u0915\u0947 Day, Week, Month \u0914\u0930 Year Find \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e MySQL DATE_ADD Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u092c\u0939\u0941\u0924 \u0939\u0940 \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 find \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964    <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT DATE_ADD('2022-01-22',INTERVAL 1 DAY), \nDATE_ADD('2022-01-22',INTERVAL 2 WEEK),\nDATE_ADD('2022-01-22',INTERVAL 3 MONTH), \nDATE_ADD('2022-01-22',INTERVAL 4 YEAR);<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"34\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-88.png?resize=640%2C34&#038;ssl=1\" alt=\"MySQL DATE_ADD FUNCTION\" class=\"wp-image-6563\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-88.png?resize=1024%2C54&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-88.png?resize=300%2C16&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-88.png?resize=768%2C40&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-88.png?w=1107&amp;ssl=1 1107w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"DATE_SUB\">DATE_SUB (Date, Interval Number Unit) : Substract Day\/Week\/Month\/Year  <\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 Date \u092e\u0947 \u0915\u094b\u0908 Number \u0918\u091f\u093e \u0915\u0930 \u092a\u093f\u091b\u0932\u0947 Day, Week, Month \u0914\u0930 Year Find \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e MySQL DATE_SUB Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u092c\u0939\u0941\u0924 \u0939\u0940 \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 find \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964   <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT DATE_SUB('2022-01-22',INTERVAL 1 DAY), \nDATE_SUB('2022-01-22',INTERVAL 2 WEEK), \nDATE_SUB('2022-01-22',INTERVAL 3 MONTH), \nDATE_SUB('2022-01-22',INTERVAL 4 YEAR);<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"35\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-89.png?resize=640%2C35&#038;ssl=1\" alt=\"MySQL DATE_SUB FUNCTION\" class=\"wp-image-6565\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-89.png?resize=1024%2C56&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-89.png?resize=300%2C16&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-89.png?resize=768%2C42&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-89.png?w=1107&amp;ssl=1 1107w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"DATEDIFF\">DATEDIFF(Date1, Date2) : Find Date Difference Between Two Dates<\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0906\u092a\u0915\u094b \u0926\u094b \u0926\u093f\u0928\u093e\u0902\u0915 \u0915\u0947 \u092c\u0940\u091a \u0915\u0947 \u0926\u093f\u0928\u094b\u0902 \u0915\u0940 \u0938\u0902\u0916\u094d\u092f\u093e Find \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e MySQL DateDiff function \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e Find \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT DATEDIFF('2022-02-22 ','2022-01-21')<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"248\" height=\"40\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-90.png?resize=248%2C40&#038;ssl=1\" alt=\"MySQL DATEDIFF FUNCTION\" class=\"wp-image-6567\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"DATE\">MySQL DATE (DateTime) : Find Date From Date Time <\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0915\u093f\u0938\u0940 \u092d\u0940 Date Time \u092e\u0947 \u0938\u0947 \u092f\u0926\u093f \u0939\u092e\u0947 Date Find \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e MySQL Date Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Datetime \u092e\u0947 \u0938\u0947 Date \u0915\u094b \u0905\u0932\u0917 \u0928\u093f\u0915\u093e\u0932 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT DATE('2022-02-22 10:25')<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"174\" height=\"38\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-91.png?resize=174%2C38&#038;ssl=1\" alt=\"MySQL DATE FUNCTION\" class=\"wp-image-6569\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"TIME\">MySQL TIME (DateTime) : Find Time From Date Time<\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0915\u093f\u0938\u0940 \u092d\u0940 Date Time \u092e\u0947 \u0938\u0947 \u092f\u0926\u093f \u0939\u092e\u0947 Time Find \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e MySQL Time Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Datetime \u092e\u0947 \u0938\u0947 Time \u0915\u094b \u0905\u0932\u0917 \u0928\u093f\u0915\u093e\u0932 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT TIME('2022-02-22 10:25')<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"175\" height=\"39\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-92.png?resize=175%2C39&#038;ssl=1\" alt=\"MySQL TIME FUNCTION\" class=\"wp-image-6571\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"NOW\">MySQL NOW() : Get Current Date &amp; Time<\/h2>\n\n\n\n<p>Current Date \u0915\u0947 \u0938\u093e\u0925 \u092f\u0926\u093f Time \u092d\u0940 \u092f\u093e\u0928\u093f \u0915\u0940 CURDATE \u0914\u0930 CURTIME \u0926\u094b\u0928\u094b\u0902 \u090f\u0915 \u0939\u0940 \u0938\u093e\u0925 \u0939\u0940 \u0928\u093f\u0915\u093e\u0932\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0939\u092e MySQL NOW \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT NOW()<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"131\" height=\"43\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-93.png?resize=131%2C43&#038;ssl=1\" alt=\"MySQL NOW FUNCTION\" class=\"wp-image-6573\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p>\u0906\u092a\u0915\u094b \u092f\u0939 MySQL Date Time Function Article \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u0939\u092e\u0947 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u090f \u0964 <\/p>\n\n\n\n<p>\u0905\u092a\u0928\u093e \u0915\u093f\u0924\u092e\u0940 \u0938\u092e\u092f \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0927\u0928\u094d\u092f\u0935\u093e\u0926 <\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Date Time \u0915\u0947 \u0915\u0941\u091b Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0907\u0938 Article \u092e\u0947 \u092c\u0924\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 \u0915\u0941\u091b Date \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 Function \u0939\u0948\u0902 \u0915\u0941\u091b Function Time \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 , \u0915\u0941\u091b Date Time \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u0914\u0930 \u0915\u0941\u091b Function Conversion \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u0939\u0948 \u0964 MySQL Date Related Function MySQL CURDATE() : Current Date MAKEDATE(Year, No [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6638,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-6528","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/mysql-date-time-function.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/6528","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=6528"}],"version-history":[{"count":95,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/6528\/revisions"}],"predecessor-version":[{"id":9240,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/6528\/revisions\/9240"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/6638"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=6528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=6528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=6528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}