DATE_SUB(curdate(), INTERVAL 1 YEAR); : DATE_SUB : Date Time Functions MySQL TUTORIALS

DATE_SUB(curdate(), INTERVAL 1 YEAR);

Related Scripts with Example Source Code in same category :
• DATE_SUB(date,INTERVAL expr unit)
• DATE_SUB(curdate(), INTERVAL 1 MICROSECOND);
• DATE_SUB(curdate(), INTERVAL 1 MINUTE);
• DATE_SUB(curdate(), INTERVAL 1 HOUR);
• DATE_SUB(curdate(), INTERVAL 1 DAY);
• DATE_SUB(curdate(), INTERVAL 1 WEEK);
• DATE_SUB(curdate(), INTERVAL 1 MONTH);
• DATE_SUB(curdate(), INTERVAL 1 QUARTER);
• DATE_SUB(curdate(), INTERVAL 1.1 SECOND_MICROSECOND);
• DATE_SUB(curdate(), INTERVAL 1 SECOND);
• DATE_SUB(curdate(), INTERVAL 1.1 SECOND);
• DATE_SUB(curdate(), INTERVAL 1.1 MINUTE_MICROSECOND);
• DATE_SUB(curdate(), INTERVAL 1.1 MINUTE_SECOND);
• select DATE_SUB(curdate(), INTERVAL 1.1 HOUR_MICROSECOND);
• select DATE_SUB(curdate(), INTERVAL 1.1 HOUR_SECOND);
• select DATE_SUB(curdate(), INTERVAL '1
• select DATE_SUB(curdate(), INTERVAL 1.1 HOUR_MINUTE); (with dot)
• select DATE_SUB(curdate(), INTERVAL '1
• select DATE_SUB(curdate(), INTERVAL 1.1 DAY_MICROSECOND);
• select DATE_SUB(curdate(), INTERVAL '1 1
• select DATE_SUB(curdate(), INTERVAL '1 1
• select DATE_SUB(curdate(), INTERVAL '1 1' DAY_HOUR);
• select DATE_SUB(curdate(), INTERVAL 1.1 SECOND_MICROSECOND);
• select DATE_SUB(curdate(), INTERVAL '1-1' YEAR_MONTH);
• select DATE_SUB(curdate(), INTERVAL '1.1' YEAR_MONTH); (with dot)
• Selects all rows with a start_date value from within the last 30 days
• Getting a date 6 months in the past
• Using DATE_SUB function to substract 55 years from current date

Leave a Comment / Note

Name (required)

email (will not be published) (required)

Website

Vérification Refresh		Enter code
Verification is used to prevent unwanted posts (spam). .