Applications.ge

Night mode
Sign up
Login
Modules
- Basics of Programming
- Problem Solving
- Git
- HTML
- CSS
- Sass
- JavaScript
- PHP
- Laravel
Meetings
Challenges
Projects
Tutorials
Channels
Notes
Resources

Applications.ge
Modules
- Basics of Programming
- Problem Solving
- Git
- HTML
- CSS
- Sass
- JavaScript
- PHP
- Laravel
Meetings
Challenges
Projects
Tutorials
Channels
Notes
Resources

Results: 1578

Notes

Newest first
Oldest first
Newest first(All)
Oldest first(All)

LAST_DAY

Function

LAST_DAY

takes date and returns the last date of the month. In the example the result is

because the year is not leap year

SELECT 
    LAST_DAY('2021-02-15')

by Valeri Tandilashvili

MySQL

Datetime functions

Full MySQL Course for Beginners

MAKETIME

Function

MAKETIME

takes three parameters as hour, minute and time and returns formatted time like:

18:15:19

SELECT 
    MAKETIME(18, 15, 19)

by Valeri Tandilashvili

MySQL

Datetime functions

Full MySQL Course for Beginners

TIMESTAMPDIFF

Function

TIMESTAMPDIFF

calculates the difference between two times. The result is in unites that we want to measure the difference between the times

SELECT 
    TIMESTAMPDIFF(DAY, '2021-03-13', '2021-03-25')

by Valeri Tandilashvili

MySQL

Datetime functions

Full MySQL Course for Beginners

DATEDIFF

Function

DATEDIFF

Calculates the number of days between the two parameters. In this example the function returns

which is the number of days between the dates

SELECT 
    DATEDIFF('2021-03-25', '2021-03-13')

The function returns

negative number

if the second date is greater than the first one. In the example the result will be

-12

SELECT 
    DATEDIFF('2021-03-13', '2021-03-25')

by Valeri Tandilashvili

MySQL

Datetime functions

Full MySQL Course for Beginners

SUBDATE

Function

SUBDATE

subtracts some amount of time from the specified date

SELECT 
    SUBDATE('2021-03-25', INTERVAL 30 DAY)

by Valeri Tandilashvili

MySQL

Datetime functions

Full MySQL Course for Beginners

ADDDATE

Function

ADDDATE

adds some amount of time to the specified date

SELECT 
    ADDDATE('2021-03-25', INTERVAL 8 DAY)

by Valeri Tandilashvili

MySQL

Datetime functions

Full MySQL Course for Beginners

CURDATE

CURDATE

returns current date with the following syntax:

YYYY-MM-DD

SELECT 
    CURDATE()

by Valeri Tandilashvili

MySQL

Datetime functions

CURRENT_DATE

CURRENT_DATE

returns current date with the following syntax:

YYYY-MM-DD

SELECT 
    CURRENT_DATE()

by Valeri Tandilashvili

MySQL

Datetime functions

SYSDATE

Returns current date and time

SELECT 
    SYSDATE()

We can pass parameter

precision

to the function that indicates milliseconds and microseconds:

SELECT 
    SYSDATE(6)

Maximum

precision

is 6, if we pass more than the supported number, we will get an error

SELECT 
    SYSDATE(7)

After running the query, the following error will be generated:

#1426 - Too big precision 7 specified for 'sysdate'. Maximum is 6

by Valeri Tandilashvili

MySQL

Datetime functions

NOW

NOW

Returns current date and time

SELECT 
    NOW()

by Valeri Tandilashvili

MySQL

Datetime functions

Results: 1578