emergingbytes.com Technology blog for data warehousing, business intelligence, iPhone Apps Development, Android Apps development and facebook applications

10Jul/130

Get First Day of Month and First Day of Last Month in Teradata

First day of last month:

select ADD_MONTHS(CURRENT_DATE - EXTRACT(DAY FROM CURRENT_DATE) + 1,-1)

First day of current month:

select CURRENT_DATE - EXTRACT(DAY FROM CURRENT_DATE) + 1
Tagged as: , Leave a comment
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

Security Challenge:
* Time limit is exhausted. Please reload the CAPTCHA.

No trackbacks yet.

» «

Categories

Technology Forum

Tags

ADSL BO BO Mobile Business Intelligence Business Objects Business Objects Mobile CAST CDR COALESCE Database Delegate Data Foundation Layer Data Transfer Bytes DATE DAY DB DD Distinct Sessions DWH EXTRACT GPRS HOUR Information Design Tool INSERT INTERVAL MINUTE Mobile BI Mobile Business Intelligence MOD MSTR Mobile NULLIFZERO POSITION Pros Cons RANDOM SAP SAP BO Mobile SECOND SELECT SP SQL SUBSTR TOREFRESH UDF URL VALUES YYYY