First day of month function in Teradata

building semantic layer
1

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 !

Smith85 (BOB member since 2009-12-10)

2 
select datecol - extract(day from datecol) + 1

Jansi :india: (BOB member since 2008-05-12)

3

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…

armel9979 (BOB member since 2008-09-27)