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?
datetime to timestamp
Moderators: chulett, rschirm, roy