Re:how to find day of the week provided from the date

[rajeevm]

Hi,

I need your help in finding the day of the week i.e, whether its sunday or monday or tuesday from the date column . I have a column in the source 'Issue_Dt' and I need to load the column in the target by using this
If the Issue_Dt is Sunday and ED_Cd is'01' then I need to append Bto R_ID else if Issue_Dt is not Monday then just pass the same column into the target.

How I find the day from the given date field (yyyy-mm-dd)

I would really appreciate your quicker responses.

Thanks
rajeevm

[chulett]

There should be a function that returns the 'day of the week' with zero being Sunday, from what I recall.

[vinothkumar]

Check WeekdayFromDate