DSXchange

in the database it is a timestamp and i want only the date and i used left(dbvariable,10) and compared it with the date which is yyyy-mm-dd and it tells me bad timestamp external representation

More details please.
Can you also copy and paste the exact error messages, rather than typing it yourself.

I do not know i to copy from director and paste it reads as folllows
odbc_enterprise_5.0 error bad timestanp external representation

kishoreramachandran wrote:I do not know i to copy from director and paste it reads as folllows

Select the log entries which shows you the warnings/Errors.
If you double click on these log entries, you get "Event Details" window.
You can copy and paste from there.

ODBC_Enterprise_5.0: ERROR: Bad timestamp external representation ' $sym_date'

in job parameter i do not see a timestamp option

Change the timestamp to string and then try doing the comparison.

but that is a database variable how can i change that

Either in the sql select using TO_CHAR() or its equivalent for your database type or using the modify stage/transformer by using the timestamptostring() function.

Kishore,

Please elaborate on your problem.
You need to give an overview as to what you are doing, what stages your are using,how and where you are getting your errors.
This will help anybody to give you suggestions more precisely.

thanks to narasimha and dsguru.

Good it got resolved
Care to share the solution please.

the problem was with the dollar sign it should have been # for the parameter which was screwing up everything.