: DATE_SUB : Date Time Functions MySQL TUTORIALS

Navioo.com

MySQL TUTORIALS » Date Time Functions » DATE_SUB »

1 2

222.1 .

Using DATE_SUB function to substract 55 years from current date

Using DATE_SUB function to substract 55 years from current date

Hits: 1211

222.2 .

Getting a date 6 months in the past

Getting a date 6 months in the past

Hits: 1146

222.3 .

Selects all rows with a start_date value from within the last 30 days

Selects all rows with a start_date value from within the last 30 days

Hits: 1187

222.4 .

select DATE_SUB(curdate(), INTERVAL '1.1' YEAR_MONTH); (with dot)

select DATE_SUB(curdate(), INTERVAL '1.1' YEAR_MONTH); (with dot)

Hits: 1165

222.5 .

select DATE_SUB(curdate(), INTERVAL '1-1' YEAR_MONTH);

select DATE_SUB(curdate(), INTERVAL '1-1' YEAR_MONTH);

Hits: 1155

222.6 .

select DATE_SUB(curdate(), INTERVAL 1.1 SECOND_MICROSECOND);

select DATE_SUB(curdate(), INTERVAL 1.1 SECOND_MICROSECOND);

Hits: 1157

222.7 .

select DATE_SUB(curdate(), INTERVAL '1 1' DAY_HOUR);

select DATE_SUB(curdate(), INTERVAL '1 1' DAY_HOUR);

Hits: 1216

222.8 .

select DATE_SUB(curdate(), INTERVAL '1 1

select DATE_SUB(curdate(), INTERVAL '1 1

Hits: 1149

222.9 .

select DATE_SUB(curdate(), INTERVAL '1 1

select DATE_SUB(curdate(), INTERVAL '1 1

Hits: 1150

222.10 .

select DATE_SUB(curdate(), INTERVAL 1.1 DAY_MICROSECOND);

select DATE_SUB(curdate(), INTERVAL 1.1 DAY_MICROSECOND);

Hits: 1207

222.11 .

select DATE_SUB(curdate(), INTERVAL '1

select DATE_SUB(curdate(), INTERVAL '1

Hits: 1075

222.12 .

select DATE_SUB(curdate(), INTERVAL 1.1 HOUR_MINUTE); (with dot)

select DATE_SUB(curdate(), INTERVAL 1.1 HOUR_MINUTE); (with dot)

Hits: 1198

222.13 .

select DATE_SUB(curdate(), INTERVAL '1

select DATE_SUB(curdate(), INTERVAL '1

Hits: 1195

222.14 .

select DATE_SUB(curdate(), INTERVAL 1.1 HOUR_SECOND);

select DATE_SUB(curdate(), INTERVAL 1.1 HOUR_SECOND);

Hits: 1248

222.15 .

select DATE_SUB(curdate(), INTERVAL 1.1 HOUR_MICROSECOND);

select DATE_SUB(curdate(), INTERVAL 1.1 HOUR_MICROSECOND);

Hits: 1210

222.16 .

DATE_SUB(curdate(), INTERVAL 1.1 MINUTE_SECOND);

DATE_SUB(curdate(), INTERVAL 1.1 MINUTE_SECOND);

Hits: 1185

222.17 .

DATE_SUB(curdate(), INTERVAL 1.1 MINUTE_MICROSECOND);

DATE_SUB(curdate(), INTERVAL 1.1 MINUTE_MICROSECOND);

Hits: 1117

222.18 .

DATE_SUB(curdate(), INTERVAL 1.1 SECOND);

DATE_SUB(curdate(), INTERVAL 1.1 SECOND);

Hits: 1293

222.19 .

DATE_SUB(curdate(), INTERVAL 1 SECOND);

DATE_SUB(curdate(), INTERVAL 1 SECOND);

Hits: 1210

222.20 .

DATE_SUB(curdate(), INTERVAL 1.1 SECOND_MICROSECOND);

DATE_SUB(curdate(), INTERVAL 1.1 SECOND_MICROSECOND);

Hits: 1178

Follow Navioo On Twitter

MySQL TUTORIALS

Navioo

Date Time Functions
» DATE_SUB

Aggregate Functions

Aggregate Functions

Cast Functions Operators

Cast Functions Operators

Comparison Functions Operators

Comparison Functions Operators

Control Flow Functions

Control Flow Functions

Cursor

Data Dictionary

Data Dictionary

Data Types

Database

Date Time Functions

Date Time Functions

Encryption Compression Functions

Encryption Compression Functions

Information Functions

Information Functions

Insert Update Delete

Insert Update Delete

Introduction

Logic Operator

Math Numeric Functions

Math Numeric Functions

Miscellaneous Functions

Miscellaneous Functions

MySQL Utilities

MySQL Utilities

Privilege

Procedure Function

Procedure Function

Regular Expressions

Regular Expressions

Select Query

String Functions

String Functions

Subquery

Table

Table Join

Trigger

View

hits counter