Date functions

seanc217 · Post by **seanc217** » Tue May 02, 2006 1:28 pm

Hi all,

I am looking for a way to calcuate the week of the month For example, 4/01/06 would calulate to week 1, while 4/8/06 would calculate to week 2.

Is there a function in DataStage to do this?

Thanks

DSguru2B · Post by **DSguru2B** » Tue May 02, 2006 2:03 pm

You will need to code a custom routine to perform this task. Keep in mind the scenario what if the 1st April 2006 is a friday, will you still consider it as the first week or no?

seanc217 · Post by **seanc217** » Tue May 02, 2006 2:06 pm

I think since I am loading an Oracle table, that I can just use the to_char function to do it.

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue May 02, 2006 2:22 pm

Curious to learn how TO_CHAR could return a week number. What are the business rules that define "week 1 in a month"? (For example read post from dsguru2b.)