Date functions Flashcards

1
Q

ADDDATE

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

ADDTIME

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

CURDATE

A

Returns the current date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

CURRENT DATE

A

Returns the current date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

CURRENT TIME

A

Returns the current time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

CURRENT TIMESTAMP

A

Returns the current date and time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

CURTIME

A

Returns the current time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

DATE

A

Extracts the date part from a datetime expression

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

DATEDIFF

A

Returns the number of days between two date values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

DATE ADD

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

DATE FORMAT

A

Formats a date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

DATE SUB

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

DAY

A

Returns the day of the month for a given date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

DAYNAME

A

Returns the weekday name for a given date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

DAYOFMONTH

A

Returns the day of the month for a given date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

DAYOFWEEK

A

Returns the weekday index for a given date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

DAYOFYEAR

A

Returns the day of the year for a given date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

EXTRACT

A

Extracts a part from a given date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

FROM DAYS

A

Returns a date from a numeric datevalue

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

HOUR

A

Returns the hour part for a given date

21
Q

LAST DAY

A

Extracts the last day of the month for a given date

22
Q

LOCALTIME

A

Returns the current date and time

23
Q

LOCALTIMESTAMP

A

Returns the current date and time

24
Q

MAKEDATE

A

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

25
Q

MAKETIME

A

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

26
Q

MICROSECOND

A

Returns the microsecond part of a time/datetime

27
Q

MINUTE

A

Returns the minute part of a time/datetime

28
Q

MONTH

A

Returns the month part for a given date

29
Q

MOTHNAME

A

Returns the name of the month for a given date

30
Q

NOW

A

Returns the current date and time

31
Q

QUARTER

A

Returns the quarter of the year for a given date value

32
Q

SECOND

A

Returns the seconds part of a time/datetime

33
Q

SEC TO TIME

A

Returns a time value based on the specified seconds

34
Q

STR TO DATE

A

Returns a date based on a string and a format

35
Q

SUBDATE

A

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

36
Q

SUBTIME

A

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

37
Q

SYSDATE

A

Returns the current date and time

38
Q

TIME

A

Extracts the time part from a given time/datetime

39
Q

TIME FORMAT

A

Formats a time by a specified format

40
Q

TIME TO SEC

A

Converts a time value into seconds

41
Q

TIMEDIFF

A

Returns the difference between two time/datetime expressions

42
Q

TIMESTAMP

A

Returns a datetime value based on a date or datetime valu

43
Q

TO DAYS

A

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

44
Q

WEEK

A

Returns the week number for a given date

45
Q

WEEKDAY

A

Returns the weekday number for a given date

46
Q

WEEKOFYEAR

A

Returns the week number for a given date

47
Q

YEAR

A

Returns the year part for a given date

48
Q

YEARWEEK

A

Returns the year and week number for a given date