CONVERSION

[karry450]

Hi friends


Can anyone tell me how to convert timestamp to date in transformer stage.

thanks

[harish_s_ampeo]

Just use to_date function as given below

to_date(column,'YYYY-MM-DD HH24:MI:SS')

[ray.wurlod]

Wrong. That function belongs in an SQL query, not in a Transformer stage.

In a Transformer stage simply take the leftmost ten characters, or the first space-delimited field, from the timestamp. This works because there are no data types in server jobs.

Code: Select all

Left(InLink.TheTimestamp,10)
Field(InLink.TheTimestamp, " ", 1, 1)

If you need an internal format date, apply an Iconv() function to that result.

[karry450]

Wrong. That function belongs in an SQL query, not in a Transformer stage.

In a Transformer stage simply take the leftmost ten characters, or the first space-delimited field, from the timestamp. T ...

thanks but how do you implement in transformer stage.

[MOHAMMAD.ISSAQ]

You can use "Left" function or "Substring".

If you're not sure of the length of the date format i,e. DD/MM/YYYY(10 Characters) or YYYYMMDD(8 Characters) then you can do like this:


Output:- Left(DSLink8.TIMESTAMP,Index(DSLink8.TIMESTAMP,' ',1))

[ray.wurlod]

A full and general solution was given in my earlier reply.

Premium membership is worth it. Less than 30c per day. 100% of this goes to the hosting and bandwidth costs incurred by DSXchange.

[jlock23]

I always use OCONV and ICONV to do conversions in date formats.