datetime to timestamp

[devsonali]

Hello All

I have to funnel two fields one of which is oracle timestamp and other is Date field into a target which is timestamp.

When I do a query the date (source column) the date appears
to be in this format 11-DEC-2006 .

To convert the date into timestamp

I am using Timestampfromdatetime(source_column,stagevariable)

where stage variable is defined to hold '00:00:00'


i am getting the following warning
Conversion error calling conversion routine timestamp_from_string data may have been lost

I am unable to figure out , where am I going wrong ?

Please suggest your views on this issue?

[chulett]

I can't confirm as I have no documentation access here, but pretty sure that function requires a true time component not a string with a time in it. And your 'source_column' needs to be a date.