Teradata SQL - First Day of a Month

visibility 904 access_time 2 years ago languageEnglish

Introduction

In Teradata, we can derive the first day of the month from a specified date.

Code snippet

The following code snippet shows the month start date of the current month:

SELECT CURRENT_DATE - EXTRACT(DAY FROM CURRENT_DATE) + 1 AS MONTH_START_DATE;

Output:

MONTH_START_DATE

1 1/02/2021


Similarly, table column or DATE expressions can be used with the function.

SELECT DATE'2021-12-31' - EXTRACT(DAY FROM DATE'2021-12-31') + 1 AS MONTH_START_DATE;

Output:

MONTH_START_DATE

1 1/12/2021


copyright This page is subject to Site terms.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

timeline Stats
Page index 1.92
More from Kontext
Trim Leading or/and Trailing Zeros in Teradata
visibility 7,663
thumb_up 2
access_time 2 years ago
Create Temporary Table - Hive SQL
visibility 1,572
thumb_up 0
access_time 2 years ago