DSXchange

I tried with that Macro ,but just that Macro name is coming not the time satmp

HI! All I have a job which is loading data in to a sequential file ,This jobs runs 5 times a day. I want to generate a file with filename concatenated with timestamp every time the job finishes. Therefore I need to generate five files a day for example: "OrderInvoice 23/06/2006 00:00:00 AM"...

I did that before but i was getting null value in datastage

Thanks for your help

Both te formats are in YYYY-MM-DD HI24:MI:SS ,iam not passing Sysdate as a parameter ,instead iam using SELECT TO_CHAR(UDT_DATE, 'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(DATETIME_ADDED, 'YYYY-MM-DD HH24:MI:SS'), to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS') AS LAST_UDT FROM edw_product_d and pulling the sysdat...

HI! All I have a date column UDT_DATE ,iam using this date to calculate the flag My condition If UDT_DATE>=(last 12 months ) Then 'Y' ELse 'N' .So i used this way If UDT_DATE>= Sysdate-365 Then 'Y' ELse 'N' .I bring the Sysdate form the source level .The problem when i tried to subract the sysdate w...

If you want to do this in query level you can use this

SELECT to_char(TO_CHAR(DATETIME_ADDED,'YYYY')-TO_CHAR(UDT_DATE,'YYYY'))||'/'||
to_char(TO_CHAR(DATETIME_ADDED,'MM')-TO_CHAR(UDT_DATE,'MM'))
||'/'||to_char(TO_CHAR(DATETIME_ADDED,'DD')-TO_CHAR(UDT_DATE,'DD')) AS DATEDIFF FROM EDW_PRODUCT_D

You can use TO_CHAR(COLUMN NAME,'YYYYMMDD') in the source query