I want to display only year or month or date from Date colum

venkates.dw · Post by **venkates.dw** » Thu Mar 12, 2009 3:45 am

Hi,

my date format is yyyy-mm-dd hh:mi:ss . from this i want to get only either year or month or date in server jobs.

Please give me reply...

Thanks in advance....

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Mar 12, 2009 3:47 am

I think Ray has answered to a very similar question from you. Did you try working based on his response?

sbass1 · Post by **sbass1** » Thu Mar 12, 2009 7:27 am

venkates.dw wrote:Hi,
Please give me reply...

Then please give us more details. What is your source data? Is it already stored in internal date format, or is your data a text string coming from a sequential file? You may want to research the SQL convert function, and the DataStage iconv and oconv functions.

DSguru2B · Post by **DSguru2B** » Thu Mar 12, 2009 8:37 am

What have you tried so far?

chulett · Post by **chulett** » Thu Mar 12, 2009 10:38 am

Year or month or day, perhaps? In any case, either substring with [] or use Field() to get just the parts you want.

DSXchange

I want to display only year or month or date from Date colum

I want to display only year or month or date from Date colum

Re: I want to display only year or month or date from Date c