date portion

kishoreramachandran · Tue Jan 16, 2007 12:49 pm

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

narasimha · Post by **narasimha** » Tue Jan 16, 2007 12:52 pm

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

kishoreramachandran · Tue Jan 16, 2007 12:56 pm

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

narasimha · Post by **narasimha** » Tue Jan 16, 2007 1:01 pm

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.

kishoreramachandran · Post by **kishoreramachandran** » Tue Jan 16, 2007 1:05 pm

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

kishoreramachandran · Post by **kishoreramachandran** » Tue Jan 16, 2007 1:14 pm

in job parameter i do not see a timestamp option

DSguru2B · Post by **DSguru2B** » Tue Jan 16, 2007 1:21 pm

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

kishoreramachandran · Post by **kishoreramachandran** » Tue Jan 16, 2007 1:25 pm

but that is a database variable how can i change that

DSguru2B · Post by **DSguru2B** » Tue Jan 16, 2007 1:28 pm

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.

narasimha · Post by **narasimha** » Tue Jan 16, 2007 1:29 pm

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.

kishoreramachandran · Post by **kishoreramachandran** » Tue Jan 16, 2007 7:51 pm

thanks to narasimha and dsguru.

narasimha · Post by **narasimha** » Tue Jan 16, 2007 7:58 pm

Good it got resolved

Care to share the solution please.

kishoreramachandran · Post by **kishoreramachandran** » Fri Jan 19, 2007 9:14 pm

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