Mysql Date , time , Datetime Functions

 ## MySQL Date and Time Functions


MySQL provides a set of functions that allow you to manipulate date and time values. These functions can be used to add or subtract time from dates, extract specific parts of dates, and format dates in various ways. Here is a list of MySQL date and time functions with a brief description of each:


### Date Functions

- `DATE()` - extracts the date part from a datetime expression.

- `DATEDIFF()` - calculates the number of days between two date values.

- `DAY()` - gets the day of the month of a date.

- `DAYNAME()` - gets the name of the weekday of a date.

- `DAYOFMONTH()` - gets the day of the month of a date.

- `DAYOFWEEK()` - gets the weekday index of a date.

- `DAYOFYEAR()` - gets the day of the year of a date.

- `FROM_DAYS()` - returns a date from a day number.

- `LAST_DAY()` - gets the last day of the month for a date.

- `MAKEDATE()` - creates a date from the year and day of year.

- `MONTH()` - gets the month of a date.

- `MONTHNAME()` - gets the name of the month of a date.

- `NOW()` - gets the current date and time.

- `PERIOD_ADD()` - adds a period to a year-month value.

- `PERIOD_DIFF()` - gets the number of months between two year-month values.

- `QUARTER()` - gets the quarter of a date.

- `TO_DAYS()` - gets the number of days since year 0.

- `WEEK()` - gets the week number of a date.

- `WEEKDAY()` - gets the weekday index of a date.

- `WEEKOFYEAR()` - gets the week number of a date.

- `YEAR()` - gets the year of a date.

- `YEARWEEK()` - gets the year and week number of a date.


### Time Functions

- `ADDTIME()` - adds a time interval to a time or datetime value.

- `CONVERT_TZ()` - converts a datetime value from one time zone to another.

- `CURTIME()` - gets the current time.

- `DATE_ADD()` - adds a time interval to a date or datetime value.

- `DATE_SUB()` - subtracts a time interval from a date or datetime value.

- `EXTRACT()` - extracts a part from a datetime value.

- `FROM_UNIXTIME()` - converts a Unix timestamp to a datetime value.

- `GET_FORMAT()` - gets a date format string.

- `LOCALTIME()` - gets the current date and time.

- `LOCALTIMESTAMP()` - gets the current date and time.

- `MAKETIME()` - creates a time value from the hour, minute, and second.

- `MICROSECOND()` - gets the microsecond part of a datetime value.

- `MINUTE()` - gets the minute part of a datetime value.

- `NOW()` - gets the current date and time.

- `SECOND()` - gets the second part of a datetime value.

- `SEC_TO_TIME()` - converts seconds to a time value.

- `STR_TO_DATE()` - converts a string to a datetime value.

- `SUBTIME()` - subtracts a time interval from a time or datetime value.

- `SYSDATE()` - gets the current date and time.

- `TIME()` - extracts the time part from a time or datetime value.

- `TIMEDIFF()` - gets the difference between two time or datetime values.

- `TIMESTAMP()` - converts a datetime value to a Unix timestamp.

- `TIMESTAMPADD()` - adds an interval to a datetime value.

- `TIMESTAMPDIFF()` - gets the difference between two datetime values.

- `TIME_FORMAT()` - formats a time value.

- `TIME_TO_SEC()` - converts a time value to seconds.

- `UNIX_TIMESTAMP()` - gets the Unix timestamp for a datetime value.

- `UTC_DATE()` - gets the current UTC date.

- `UTC_TIME()` - gets the current UTC time.

- `UTC_TIMESTAMP()` - gets the current UTC date and time.

- `WEEK()` - gets the week number of a date.

- `WEEKDAY()` - gets the weekday index of a date.

- `WEEKOFYEAR()` - gets the week number of a date.


### Datetime Functions

- `ADDDATE()` - adds a time interval to a date or datetime value.

- `ADDTIME()` - adds a time interval to a time or datetime value.

- `CONVERT_TZ()` - converts a datetime value from one time zone to another.

- `CURDATE()` - gets the current date.

- `CURRENT_DATE()` - gets the current date.

- `CURRENT_TIME()` - gets the current time.

- `CURRENT_TIMESTAMP()` - gets the current date and time.

- `CURTIME()` - gets the current time.

- `DATE()` - extracts the date part from a datetime expression.

- `DATEDIFF()` - calculates the number of days between two date values.

- `DATE_ADD()` - adds a time interval to a date or datetime value.

- `DATE_FORMAT()` - formats a date or datetime value.

- `DATE_SUB()` - subtracts a time interval from a date or datetime value.

- `DAY()` - gets the day of the month of a date.

- `DAYNAME()` - gets the name of the weekday of a date.

- `DAYOFMONTH()` - gets the day of the month of a date.

- `DAYOFWEEK()` - gets the weekday index of a date.

- `DAYOFYEAR()` - gets the day of the year of a date.

- `EXTRACT()` - extracts a part from a datetime value.

- `FROM_DAYS()` - returns a date from a day number.

- `FROM_UNIXTIME()` - converts a Unix timestamp to a datetime value.

- `GET_FORMAT()` - gets a date format string.

- `HOUR()` - gets the hour part of a datetime value.

- `LAST_DAY()` - gets the last day of the month for a date.

- `LOCALTIME()` - gets the current date and time.

- `LOCALTIMESTAMP()` - gets the current date and time.

- `MAKEDATE()` - creates a date from the year and day of year.

- `MAKETIME()` - creates a time value from the hour, minute, and second.

- `MICROSECOND()` - gets the microsecond part of a datetime value.

- `MINUTE()` - gets the minute part of a datetime value.

- `MONTH()` - gets the month of a date.

- `MONTHNAME()` - gets the name of the month of a date.

- `NOW()` - gets the current date and time.

- `PERIOD_ADD()` - adds a period to a year-month value.

- `PERIOD_DIFF()` - gets the number of months between two year-month values.

- `QUARTER()` - gets the quarter of a date.

- `SECOND()` - gets the second part of a datetime value.

- `SEC_TO_TIME()` - converts seconds to a time value.

- `STR_TO_DATE()` - converts a string to a datetime value.

- `



Comments

Post a Comment

Popular posts from this blog

Read and Navigate XML - Beautiful Soup

 ### How to read and navigate XML There is a Python library called BeautifulSoup, which makes reading in and parsing XML data easier. Here is the link to the documentation: [Beautiful Soup Documentation](https://www.crummy.com/software/BeautifulSoup/) The find() method will find the first place where an xml element occurs. For example using find('record') will return the first record in the xml file: ```xml <record>   <field name="Country or Area" key="ABW">Aruba</field>   <field name="Item" key="SP.POP.TOTL">Population, total</field>   <field name="Year">1960</field>   <field name="Value">54211</field> </record> ``` The find_all() method returns all of the matching tags. So find_all('record') would return all of the elements with the `<record>` tag. Run the code cells below to get a basic idea of how to navigate XML with BeautifulSoup. To naviga...
Read more

difference-between-stream-processing-and-message-processing

 difference-between-stream-processing-and-message-processing Message Processing implies operations on and/or using  individual  messages. Stream Processing encompasses operations on and/or using individual messages as well as operations on collection of messages as they flow into the system. For e.g., let's say transactions are coming in for a payment instrument - stream processing can be used to continuously compute hourly average spend. In this case - a sliding window can be imposed on the stream which picks up messages within the hour and computes average on the amount. Such figures can then be used as inputs to fraud detection systems Although Rabbit supports streaming, it was actually not built for it(see Rabbit´s web site) Rabbit is a Message broker and Kafka is a event streaming platform. Kafka can handle a huge number of 'messages' towards Rabbit. Kafka is a log while Rabbit is a queue which means that if once consumed, Rabbit´s messages are not there anymore in c...
Read more

WordNet in Python

Image
  WordNet   is an English dictionary which is a part of   Natural Language Tool Kit   (NLTK) for Python. This is an extensive library built to make   Natural Language Processing   (NLP) easy. Some basic functions will be discussed in this article. To start using WordNet, you have to import it first: from  nltk.corpus  import  wordnet Synsets and Lemmas In WordNet, similar words are grouped into a set known as a  Synset  (short for  Synonym-set ). Every Synset has a name, a part-of-speech, and a number. The words in a Synset are known as  Lemmas . Getting Synsets The function  wordnet.synsets('word')   returns an array  containing all the Synsets related to the word passed to it as the argument. Example: print ( wordnet.sysnets ( 'room' )) Output: [Synset(‘room.n.01’), Synset(‘room.n.02’), Synset(‘room.n.03’), Synset(‘room.n.04’), Synset(‘board.v.02’)] The method returned five Synsets; four have the name...
Read more