while convert timespamp to string getting warnings
Moderators: chulett, rschirm, roy
while convert timespamp to string getting warnings
Hi Friends,
While changing from timespamp to string i am getting below warning and data showing null, i tried some ways but again and agin showing the same warning, can any one help in this solution.
APT_CombinedOperatorController(0),0: Data string '19971001' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %dd.
While changing from timespamp to string i am getting below warning and data showing null, i tried some ways but again and agin showing the same warning, can any one help in this solution.
APT_CombinedOperatorController(0),0: Data string '19971001' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %dd.
Re: while convert timespamp to string getting warnings
Try "StringToTimeStamp(In.column:" 00:00:00","%YYYY%MM%DD %HH:%NN:%SS")
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: while convert timespamp to string getting warnings
I think he want to convert Timestamp to String ""while convert timespamp to string getting warnings""ArndW wrote:Try "StringToTimeStamp(In.column:" 00:00:00","%YYYY%MM%DD %HH:%NN:%SS") ...
RAJ
Re: while convert timespamp to string getting warnings
from TimestampToString
ArndW wrote:Try "StringToTimeStamp(In.column:" 00:00:00","%YYYY%MM%DD %HH:%NN:%SS") ...
The syntax is wrong. Explain "not working", please and include the error message.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
When i use this
TimestampToString(LNK_CONV_TRANS2.SERVICE,"%yyyy-%mm-%dd") in Trnsformer showing below warning
APT_CombinedOperatorController(0),0: Data string '2009-11-01' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': the data string has fewer characters than expected.
TimestampToString(LNK_CONV_TRANS2.SERVICE,"%yyyy-%mm-%dd") in Trnsformer showing below warning
APT_CombinedOperatorController(0),0: Data string '2009-11-01' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': the data string has fewer characters than expected.
chulett wrote:'19971001' is not a Timestamp. ...
'2009-11-01' is a Date and cannot be converted to a timestamp they way you are writing it.
Try :
Try :
Code: Select all
TimestampToString(LNK_CONV_TRANS2.SERVICE:' 00:00:00',"%yyyy-%mm-%dd %hh:%nn:%ss")
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>