Hi,
In the transformer stage, I am getting the following warning message: TransformerStage 0: Conversion error calling conversion routine timestamp_from_string data may have been lost
Source column name: FutureDate
Data type:Varchar (10) - nullable-YES
Sample data:
'1999-12-31'
'1995-10-25'
As per the below reference link, I have modified the code and it is working fine in one environment.
But when I run same in another environment, I am facing the above warning message.
viewtopic.php?t=135790&highlight=timest ... +been+lost
If Trim(NullToEmpty(link.FutureDate)) = '' Then
''
Else
StringToTimestamp(link.FutureDate : '-00-00-00', '%yyyy-%mm-%dd-%hh-%nn-%ss')
Output column: Futuredate
DataType: Timestamp Length(23) Scale(3). -Nullable -NO
Sample data:
'1999-12-31 00:00:00'
'1995-10-25 00:00:00'
Any help greatly appreciated,
Regards,
SuRi
timestamp_from_string conversion warnings
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
I wonder if it might be an implicit string conversion in the transform stage. If you use the value "-12-30-30" for your time component, is your output correct or still 00:00:00?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am