Hi,
I am using the StringToTimestamp function in the transformer.
I am reading a char field 26 length(no scale) trying to convert into a timestamp.
But the problem is
for example:
Input : 2005-10-14-19:45:22.666666 CHAR(26)
Even after using this format timestamp_from_string(timestamp,"%yyyy-%mm-%dd%hh:%nn:%ss.6")
Output : 2005-10-14 19:45:22 Timestamp(26)
How should I get the microsecond fields.
Thanks
String to timestamp conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Tue Aug 10, 2004 11:07 am
- Location: Mclean VA
It seems that PX has a bug with string and timestamp with millisecond portion conversions. Please take a look at this thread
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 46
- Joined: Tue Aug 10, 2004 11:07 am
- Location: Mclean VA