Hi All,
Am working on migrating jobs from DS 7.5 to DS8.7 , There is a instance where they are converting a Timestamp to a string.
Am unable to get the microseconds printed out correctly. I used the below mentioned function and got the output as 17530101000000.000
Is there a direct way to get the output without the dot or should i use other functions to remove it
TimestampToString(DSLink2.ATXR_TM,"%yyyy%mm%dd%hh%nn%ss.3")
Desired Output : -
Input Data - 1753-01-01 00:00:00.000000
Output Data - 17530101000000000 but am getting 17530101000000.000
Timestamp to String Conversion with microseconds
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Sun Dec 26, 2010 12:08 am
- Location: bangalore
Re: Timestamp to String Conversion with microseconds
Use convert function
convert('.','',columnname)
Hope this will help you
convert('.','',columnname)
Hope this will help you