Hi,
I am constructing a timestamp from two input fields, inp_date and inp_time, and from a literal of '00'. by way of manipulation i am populating a stage variable, DateRed, with the time stamp in the format
%yyyy-%mm-%dd %hh:%nn:%ss.6. an exapmle of the string would be 2008-05-01 21:21:305600. so i am trying to do the convert as stringtotimestamp(DateRed, '%yyyy-%mm-%dd %hh:%nn:%ss.6').
As you can see i am trying to get the output to include micro seconds.
I am writing the output to a sequential file currently, just to check the output. the time stamp is coming out but is not carrying the micro seconds beyond the first 2 digits.
Any thoughts or suggestions would be welcomed.
Ultimately looking to sort the file by this field so need it to be correct.
Thanks
JOhn Fitz
String to timestamp conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 72
- Joined: Tue Feb 05, 2008 4:38 am
-
- Participant
- Posts: 72
- Joined: Tue Feb 05, 2008 4:38 am
-
- Participant
- Posts: 72
- Joined: Tue Feb 05, 2008 4:38 am
-
- Participant
- Posts: 72
- Joined: Tue Feb 05, 2008 4:38 am
-
- Participant
- Posts: 72
- Joined: Tue Feb 05, 2008 4:38 am