<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="fr">
	<id>http://wiki.les-noulot.fr/index.php?action=history&amp;feed=atom&amp;title=Mysql</id>
	<title>Mysql - Historique des versions</title>
	<link rel="self" type="application/atom+xml" href="http://wiki.les-noulot.fr/index.php?action=history&amp;feed=atom&amp;title=Mysql"/>
	<link rel="alternate" type="text/html" href="http://wiki.les-noulot.fr/index.php?title=Mysql&amp;action=history"/>
	<updated>2026-11-17T08:58:50Z</updated>
	<subtitle>Historique des versions pour cette page sur le wiki</subtitle>
	<generator>MediaWiki 1.33.0</generator>
	<entry>
		<id>http://wiki.les-noulot.fr/index.php?title=Mysql&amp;diff=325&amp;oldid=prev</id>
		<title>Sebastien : Page créée avec « =Mysql=  ==MySQL Date and Time Functions==  {| class=&quot;wikitable&quot; |-- ! Name !! Description |- |ADDDATE()||Adds dates |- |ADDTIME()||Adds time |- |CONVERT_TZ()||Converts fr... »</title>
		<link rel="alternate" type="text/html" href="http://wiki.les-noulot.fr/index.php?title=Mysql&amp;diff=325&amp;oldid=prev"/>
		<updated>2016-09-13T10:43:55Z</updated>

		<summary type="html">&lt;p&gt;Page créée avec « =Mysql=  ==MySQL Date and Time Functions==  {| class=&amp;quot;wikitable&amp;quot; |-- ! Name !! Description |- |ADDDATE()||Adds dates |- |ADDTIME()||Adds time |- |CONVERT_TZ()||Converts fr... »&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Nouvelle page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;=Mysql=&lt;br /&gt;
&lt;br /&gt;
==MySQL Date and Time Functions==&lt;br /&gt;
&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
|--&lt;br /&gt;
! Name !! Description&lt;br /&gt;
|-&lt;br /&gt;
|ADDDATE()||Adds dates&lt;br /&gt;
|-&lt;br /&gt;
|ADDTIME()||Adds time&lt;br /&gt;
|-&lt;br /&gt;
|CONVERT_TZ()||Converts from one timezone to another&lt;br /&gt;
|-&lt;br /&gt;
|CURDATE()||Returns the current date&lt;br /&gt;
|-&lt;br /&gt;
|CURRENT_DATE(), CURRENT_DATE||Synonyms for CURDATE()&lt;br /&gt;
|-&lt;br /&gt;
|CURRENT_TIME(), CURRENT_TIME||Synonyms for CURTIME()&lt;br /&gt;
|-&lt;br /&gt;
|CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP||Synonyms for NOW()&lt;br /&gt;
|-&lt;br /&gt;
|CURTIME()||Returns the current time&lt;br /&gt;
|-&lt;br /&gt;
|DATE_ADD()||Adds two dates&lt;br /&gt;
|-&lt;br /&gt;
|DATE_FORMAT()||Formats date as specified&lt;br /&gt;
|-&lt;br /&gt;
|DATE_SUB()||Subtracts two dates&lt;br /&gt;
|-&lt;br /&gt;
|DATE()||Extracts the date part of a date or datetime expression&lt;br /&gt;
|-&lt;br /&gt;
|DATEDIFF()||Subtracts two dates&lt;br /&gt;
|-&lt;br /&gt;
|DAY()||Synonym for DAYOFMONTH()&lt;br /&gt;
|-&lt;br /&gt;
|DAYNAME()||Returns the name of the weekday&lt;br /&gt;
|-&lt;br /&gt;
|DAYOFMONTH()||Returns the day of the month (1-31)&lt;br /&gt;
|-&lt;br /&gt;
|DAYOFWEEK()||Returns the weekday index of the argument&lt;br /&gt;
|-&lt;br /&gt;
|DAYOFYEAR()||Returns the day of the year (1-366)&lt;br /&gt;
|-&lt;br /&gt;
|EXTRACT||Extracts part of a date&lt;br /&gt;
|-&lt;br /&gt;
|FROM_DAYS()||Converts a day number to a date&lt;br /&gt;
|-&lt;br /&gt;
|FROM_UNIXTIME()||Formats date as a UNIX timestamp&lt;br /&gt;
|-&lt;br /&gt;
|HOUR()||Extracts the hour&lt;br /&gt;
|-&lt;br /&gt;
|LAST_DAY||Returns the last day of the month for the argument&lt;br /&gt;
|-&lt;br /&gt;
|LOCALTIME(), LOCALTIME||Synonym for NOW()&lt;br /&gt;
|-&lt;br /&gt;
|LOCALTIMESTAMP, LOCALTIMESTAMP()||Synonym for NOW()&lt;br /&gt;
|-&lt;br /&gt;
|MAKEDATE()||Creates a date from the year and day of year&lt;br /&gt;
|-&lt;br /&gt;
|MAKETIME||MAKETIME()&lt;br /&gt;
|-&lt;br /&gt;
|MICROSECOND()||Returns the microseconds from argument&lt;br /&gt;
|-&lt;br /&gt;
|MINUTE()||Returns the minute from the argument&lt;br /&gt;
|-&lt;br /&gt;
|MONTH()||Returns the month from the date passed&lt;br /&gt;
|-&lt;br /&gt;
|MONTHNAME()||Returns the name of the month&lt;br /&gt;
|-&lt;br /&gt;
|NOW()||Returns the current date and time&lt;br /&gt;
|-&lt;br /&gt;
|PERIOD_ADD()||Adds a period to a year-month&lt;br /&gt;
|-&lt;br /&gt;
|PERIOD_DIFF()||Returns the number of months between periods&lt;br /&gt;
|-&lt;br /&gt;
|QUARTER()||Returns the quarter from a date argument&lt;br /&gt;
|-&lt;br /&gt;
|SEC_TO_TIME()||Converts seconds to 'HH:MM:SS' format&lt;br /&gt;
|-&lt;br /&gt;
|SECOND()||Returns the second (0-59)&lt;br /&gt;
|-&lt;br /&gt;
|STR_TO_DATE()||Converts a string to a date&lt;br /&gt;
|-&lt;br /&gt;
|SUBDATE()||When invoked with three arguments a synonym for DATE_SUB()&lt;br /&gt;
|-&lt;br /&gt;
|SUBTIME()||Subtracts times&lt;br /&gt;
|-&lt;br /&gt;
|SYSDATE()||Returns the time at which the function executes&lt;br /&gt;
|-&lt;br /&gt;
|TIME_FORMAT()||Formats as time&lt;br /&gt;
|-&lt;br /&gt;
|TIME_TO_SEC()||Returns the argument converted to seconds&lt;br /&gt;
|-&lt;br /&gt;
|TIME()||Extracts the time portion of the expression passed&lt;br /&gt;
|-&lt;br /&gt;
|TIMEDIFF()||Subtracts time&lt;br /&gt;
|-&lt;br /&gt;
|TIMESTAMP()||With a single argument, this function returns the date or datetime expression. With two arguments, the sum of the arguments&lt;br /&gt;
|-&lt;br /&gt;
|TIMESTAMPADD()||Adds an interval to a datetime expression&lt;br /&gt;
|-&lt;br /&gt;
|TIMESTAMPDIFF()||Subtracts an interval from a datetime expression&lt;br /&gt;
|-&lt;br /&gt;
|TO_DAYS()||Returns the date argument converted to days&lt;br /&gt;
|-&lt;br /&gt;
|UNIX_TIMESTAMP()||Returns a UNIX timestamp&lt;br /&gt;
|-&lt;br /&gt;
|UTC_DATE()||Returns the current UTC date&lt;br /&gt;
|-&lt;br /&gt;
|UTC_TIME()||Returns the current UTC time&lt;br /&gt;
|-&lt;br /&gt;
|UTC_TIMESTAMP()||Returns the current UTC date and time&lt;br /&gt;
|-&lt;br /&gt;
|WEEK()||Returns the week number&lt;br /&gt;
|-&lt;br /&gt;
|WEEKDAY()||Returns the weekday index&lt;br /&gt;
|-&lt;br /&gt;
|WEEKOFYEAR()||Returns the calendar week of the date (1-53)&lt;br /&gt;
|-&lt;br /&gt;
|YEAR()||Returns the year&lt;br /&gt;
|-&lt;br /&gt;
|YEARWEEK()||Returns the year and week&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
Nb.: http://www.tutorialspoint.com/mysql/mysql-date-time-functions.htm&lt;/div&gt;</summary>
		<author><name>Sebastien</name></author>
		
	</entry>
</feed>