How to Display the Day from the date value in parallel job

[nagarjuna900]

HI,

in datastage 7.5 ( parallel jobs), how to display the 'day' from the Date value.


Thanks,

[chulett]

Display? And by "day" do you just mean the day number (1-31) or the day name? Regardless, check the DateToString() function and use the appropriate 'Date format string'.

[nagarjuna900]

Thanks,

But by using DateToString(), there is a option to display the day number ( 1-31), how to display the day name?

[chulett]

Same way - by using the appropriate date format string: %eee off the top of my head. Check the docs.

[vinothkumar]

Did you check 'WeekdayFromDate' function.

[nagarjuna900]

the WeekDayFromDate function will display the number of the day in week, it will not display the name of the day.

Thanks,

[vinothkumar]

Field('SUNDAY|MONDAY|TUESDAY|WEDNESDAY|THURSDAY|FRIDAY|SATURDAY','|',WeekdayFromDate(CAL_DATE)+1,1).. Can you try something like t his ?

[chulett]

Why for? The proper solution is far more simpler and has already been posted.

[vinothkumar]

Is that option available in V7.5.x

[chulett]

What 'option'? Regardless, check your docs and let us know.

[vinothkumar]

I did a search for %E in Parallel job developers guide (V7.5.2 in my machine). I am not able to find.

[ray.wurlod]

There's a table of date format tags (including "%eeee") in Chapter 2 of the Parallel Job Developer's Guide

It may be elsewhere in the version 7.5 manual, but I'd be pretty confident it's in there somewhere.

[vinothkumar]

Thanks for the reply Ray. The Date format tags (i.e %eee) that you mentioned are available in PDF's which comes with V8.0. It is not there in V7.5 pdfs

[chulett]

Try it... and if it doesn't work, then fall back on one of the other options posted.