BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

IBIS 2014: Limitless BI 2.0 
IBIS 2014: Limitless BI 2.0 (Opens a new window)  

General Notice: Upcoming Events: BONYMAUG: May 14, BI2014 Nice, France: May 21.

First day of month function in Teradata


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Smith85
Principal Member
Principal Member



Joined: 10 Dec 2009

Posts: 181



PostPosted: Fri Jul 29, 2011 5:50 pm 
Post subject: First day of month function in Teradata

Hi,

Is there any logic to find the first day of a month (for a year) in Teradata?

I want to list 12 dates - all of them should be the first day of 12 months.

Thanks !
Back to top
Jansi
Forum Fanatic
Forum Fanatic



Joined: 12 May 2008
ASUG Icon
Posts: 6544


flag
PostPosted: Sat Jul 30, 2011 6:34 pm 
Post subject: Re: First day of month function in Teradata

Code:
select datecol - extract(day from datecol) + 1

_________________
Search is your friend.
I can do all things through Christ who strengthens me. Philippians 4 : 13
God is your protective shade! Wanna read about Your protective shade?!
Back to top
armel9979
Forum Member
Forum Member



Joined: 27 Sep 2008

Posts: 21



PostPosted: Wed Aug 03, 2011 9:37 pm 
Post subject: Re: First day of month function in Teradata

Hi, you can also do a case when statement here to define all the first day of months for all months. The teradata sql syntax for dates can be used in the designer. Just make sure that you get the right syntax because whatever you input in the select statement of the designer object definition will return a parse error message. This can be ignored though...

To make sure you are using the correct syntax, you can test your query in the teradata sql assistant first and then just paste your select statement.

If you want to test your date objects in deski, webi or webi rich client, you can just add other objects from the universe.

Hope this helps...
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0446 seconds using 17 queries. (SQL 0.0026 Parse 0.0347 Other 0.0073)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo