Hi,
I am using current_timestamp in transformer which gives ouput 2012-05-05 08:05:37
user want it to be 05/05/2012 08:05:37 . Any idea who should i do it in transformer.
Thanks
conversation of current_timestamp
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Use TimestampToString(CurrentTimestamp(), "%mm/%dd/%yyyy %hh:%nn:%ss")
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try with peek stage
Try to load data in to peek, if you are using parellel jobs.
If that is working as per your requirmment.
If that is working as per your requirmment.
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Just a hunch. I think his target is a Timestamp field rather than a 'String' that holds a timestamp value. This could be the reason why DataStage is trying to compare the output of the TimestampToString with the default DataStage format and consequently warning the user about the mismatch
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: