conversation of current_timestamp

times29 · Post by **times29** » Tue May 08, 2012 10:18 am

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

jerome_rajan · Post by **jerome_rajan** » Tue May 08, 2012 10:46 am

Use TimestampToString(CurrentTimestamp(), "%mm/%dd/%yyyy %hh:%nn:%ss")

times29 · Post by **times29** » Tue May 08, 2012 6:27 pm

i get warnings while doing it
Data string '04/24/2012 04:20:36' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': the value for tag %yyyy has fewer characters than expected.

Kryt0n · Post by **Kryt0n** » Tue May 08, 2012 7:01 pm

You have got your output column as a varchar?

ray.wurlod · Post by **ray.wurlod** » Tue May 08, 2012 7:01 pm

Are you sure you used TimestampToString() function?

sreewin7 · Post by **sreewin7** » Wed May 09, 2012 9:56 am

Try to load data in to peek, if you are using parellel jobs.
If that is working as per your requirmment.

jerome_rajan · Post by **jerome_rajan** » Wed May 09, 2012 9:59 am

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

ray.wurlod · Post by **ray.wurlod** » Wed May 09, 2012 4:01 pm

Another example of why it is so important to post the complete error message - we would have been able to see which stage generated it.

DSXchange

conversation of current_timestamp

conversation of current_timestamp

Try with peek stage