Time stamp

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
datastagehunter
Participant
Posts: 22
Joined: Mon Oct 10, 2005 10:11 am
Location: u.s.a
Contact:

Time stamp

Post by datastagehunter »

Hi
system date its format time stamp in source system, we need characteristic format in target system, in order that timestamp only year and month, please advice me how can we get this one
hi
i want to learn datastage which was use ful for emprove my skills
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

What is your source, and what is your target? Different stages do different things.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
sb_akarmarkar
Participant
Posts: 232
Joined: Fri Sep 30, 2005 4:52 am
Contact:

Post by sb_akarmarkar »

As i understand from ...Hmmm..
Use substrings or Field to extract Data from timestamp....Use OCONV and ICONV to get year and month... :)

Read Ascential PDF ..... :arrow:

Thanks,
Anupam
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The answer to the original question is "extract the year and month from the timestamp". If your source is standards-compliant, and the timestamp conforms to ISO 8601, then the first seven characters of the timestamp contain the year and month. Because server jobs have no internal data types, it would be sufficent to use Left() or Substrings() to extract the leftmost seven characters. To remove the delimiter character ("-") you could use Convert() or Oconv() function.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kiran_418
Participant
Posts: 40
Joined: Tue Feb 22, 2005 11:12 am

Post by kiran_418 »

Frankly i didnt understand the question. Can you please explain whats the issue.
Thanks
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

If I the question properly and as explained and to explain you the issue is to "extract the year and month from the timestamp".
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply