Date conversion From flat file to Sql Server table

[kbsuryadev]

Ray,

It worked when i used datatype as datetime.
Oconv(Iconv(DSLink3.Field001, "DMDY"), "D-YMD[4,2,2]") : " 00:00:00"
Result is:
1/06/2008 2008-01-06 00:00:00.000

how can i display in this format >>> 01-06-2008 00:00:00:000

<<<it's not working when i use timestamp as datatype though.>>>


Thank you, i appreciate your help.

[kbsuryadev]

This is the error when i use the datatype as timestamp on the target


TCorp..Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO test_Cashier_Writeback(property, data_date, cashier_id, dept, category, outlet, cashier_fname, cashier_lname, Infogen_cash, priorday_cash_timing, currentday_cash_timing, tips_paidout, priorday_tip_adj, currentday_tip_adj, accountable_cash, cashdrop_amt, dueback_amt, bank_amt, adjusted_cash, cash_diff) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=S1010, DBMS.CODE=0
[DataStage][SQL Client]Function call is illegal at this point

property = "MGM Grand"
data_date = 2008-01-07 00:00:00
cashier_id = "100040226"
dept = "30317"
category = "FOODBEVG"
outlet = "Starbucks Casino"
cashier_fname = "George"
cashier_lname = "Toldness"
Infogen_cash = 516.65
priorday_cash_timing = 0.00
currentday_cash_timing = 0.00
tips_paidout = 3.00
priorday_tip_adj = 0.00
currentday_tip_adj = 0.00
accountable_cash = 513.65
cashdrop_amt = 508.60
dueback_amt = 0.00
bank_amt = 0.00
adjusted_cash = 508.60
cash_diff = -5.05