Date functions

Question 1

ADDDATE

Answer 1

Adds a time/date interval to a date and then returns the date

Question 2

ADDTIME

Answer 2

Adds a time interval to a time/datetime and then returns the time/datetime

Question 3

CURDATE

Answer 3

Returns the current date

Question 4

CURRENT DATE

Answer 4

Returns the current date

Question 5

CURRENT TIME

Answer 5

Returns the current time

Question 6

CURRENT TIMESTAMP

Answer 6

Returns the current date and time

Question 7

CURTIME

Answer 7

Returns the current time

Question 8

DATE

Answer 8

Extracts the date part from a datetime expression

Question 9

DATEDIFF

Answer 9

Returns the number of days between two date values

Question 10

DATE ADD

Answer 10

Adds a time/date interval to a date and then returns the date

Question 11

DATE FORMAT

Answer 11

Formats a date

Question 12

DATE SUB

Answer 12

Subtracts a time/date interval from a date and then returns the date

Question 13

DAY

Answer 13

Returns the day of the month for a given date

Question 14

DAYNAME

Answer 14

Returns the weekday name for a given date

Question 15

DAYOFMONTH

Answer 15

Returns the day of the month for a given date

Question 16

DAYOFWEEK

Answer 16

Returns the weekday index for a given date

Question 17

DAYOFYEAR

Answer 17

Returns the day of the year for a given date

Question 18

EXTRACT

Answer 18

Extracts a part from a given date

Question 19

FROM DAYS

Answer 19

Returns a date from a numeric datevalue

Question 20

HOUR

Answer 20

Returns the hour part for a given date

Question 21

LAST DAY

Answer 21

Extracts the last day of the month for a given date

Question 22

LOCALTIME

Answer 22

Returns the current date and time

Question 23

LOCALTIMESTAMP

Answer 23

Returns the current date and time

Question 24

MAKEDATE

Answer 24

Creates and returns a date based on a year and a number of days value

Question 25

MAKETIME

Answer 25

Creates and returns a time based on an hour, minute, and second value

Question 26

MICROSECOND

Answer 26

Returns the microsecond part of a time/datetime

Question 27

MINUTE

Answer 27

Returns the minute part of a time/datetime

Question 28

MONTH

Answer 28

Returns the month part for a given date

Question 29

MOTHNAME

Answer 29

Returns the name of the month for a given date

Question 30

NOW

Answer 30

Returns the current date and time

Question 31

QUARTER

Answer 31

Returns the quarter of the year for a given date value

Question 32

SECOND

Answer 32

Returns the seconds part of a time/datetime

Question 33

SEC TO TIME

Answer 33

Returns a time value based on the specified seconds

Question 34

STR TO DATE

Answer 34

Returns a date based on a string and a format

Question 35

SUBDATE

Answer 35

Subtracts a time/date interval from a date and then returns the date

Question 36

SUBTIME

Answer 36

Subtracts a time interval from a datetime and then returns the time/datetime

Question 37

SYSDATE

Answer 37

Returns the current date and time

Question 38

TIME

Answer 38

Extracts the time part from a given time/datetime

Question 39

TIME FORMAT

Answer 39

Formats a time by a specified format

Question 40

TIME TO SEC

Answer 40

Converts a time value into seconds

Question 41

TIMEDIFF

Answer 41

Returns the difference between two time/datetime expressions

Question 42

TIMESTAMP

Answer 42

Returns a datetime value based on a date or datetime valu

Question 43

TO DAYS

Answer 43

Returns the number of days between a date and date "0000-00-00"

Question 44

WEEK

Answer 44

Returns the week number for a given date

Question 45

WEEKDAY

Answer 45

Returns the weekday number for a given date

Question 46

WEEKOFYEAR

Answer 46

Returns the week number for a given date

Question 47

YEAR

Answer 47

Returns the year part for a given date

Question 48

YEARWEEK

Answer 48

Returns the year and week number for a given date