DSXchange

ray.wurlod wrote:The timestamp in quotes is a format string. You do not require this if your timestamp matches the default timestamp format for the job. ...

thanks ray,,my time format matches for the job, but its still asking me to enter in quotes without that its not accepting

thanks

kumar_s wrote:If your timestamp is with ' ', which is in string format, try using StringToTimestamp to convert to timestamp and later you can tyr using the mentioned function. ...

thanks for response,,my timestamp is in normal form with 18/12/1979 12:30:55

thanks

us1aslam1us wrote:Hi Thati,

Code: Select all

TimestampToTime(DSLink3.columnname)

That will do the job.

Sam

thanks for the reply sam,, i did try that but it just gives the date as ******
and time rounded as 0 like 00:00:00

help on this wud be apreciated.

thanks

ray.wurlod wrote:You do have it. Use the Expression Editor in a Transformer stage. It will appear in among the available Functions. ...

thanks for ur reply,,i found timestamptodate function and when i am trying to use it it gives timestamp qoute,,can you pls help me wat to enter in that

DateFromTimestamp() and TimeFromTimestamp() functions seem to be the obvious candidates. You will need a format string if your timestamp does not correspond to your project's default format. ... thanks for ur reply ray,,but i dont have DateFromTimestamp() in my DS7.5.1,, can you please explain more...

hi,,

i have got a query where in i will get date and timestamp like
12/10/2005 11:20:21
i need to transform that into two colums in the next stage with date and time as a seperate columns.

help is appreciated
thanks

Can someone pls tell me the way to test the job if its working as expected or not before i can send it to testing department.

thanks
prashant

thanks a lot for ur reply guys, i was trying to add in transformer..

hi,,

i am very much new to datastage, i am trying to add an extra column to an exisiting columns.. is there any stage with which we can do this.

thanks

can someone pls tell me if they have faced any common probs with banking projects, i am new to banking project and attending interview, so pls tell me any imp tips

thanks