Hi All,
Please let me know how to generate the Time stamp value in the transformer stage in the 2008-09-24 03:35:55 format.
Thanks,
Vivek
Generate Time Stamp Value
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Thu Feb 22, 2007 12:39 pm
- Location: Mumbai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is something you will need over and over: the ability to generate the current date/time as a timestamp. I advise that you create a Transform or even a Routine. I call mine NowAsTimestamp.
If you want to generate a timestamp from other input, please advise what that input looks like, as Wolfgang already asked. Or simply adapt the above code.
Code: Select all
Oconv(Date(),"D-YMD[4,2,2]") : " " : Oconv(Time(),"MTS:")
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 30
- Joined: Thu Feb 22, 2007 12:39 pm
- Location: Mumbai
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
-
- Participant
- Posts: 11
- Joined: Mon Feb 25, 2008 5:53 am
- Location: Hyderabad
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
U didn't ask about generating timestamps.
The user may not want the job start timestamp - the value required may be "now". For long-running jobs this can be quite different from the job start timestamp. In this case prefer Date() and Time() functions, because the system variables @DATE and @TIME are set when the job starts and are not updated.
The user may not want the job start timestamp - the value required may be "now". For long-running jobs this can be quite different from the job start timestamp. In this case prefer Date() and Time() functions, because the system variables @DATE and @TIME are set when the job starts and are not updated.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.