Conversion of ":" in Timestamp to "."
Posted: Tue May 10, 2011 7:39 am
Hi Guys,
I am getting Time in one column and Date in one Column. Both of them are char fields.
I am concanatening them to form a timestamp using the below codel
But i want to replace the : coming in the timestamp to . .
Can somebody help me out with this.
Cheers!!!!
I am getting Time in one column and Date in one Column. Both of them are char fields.
I am concanatening them to form a timestamp using the below codel
Code: Select all
If StringToDecimal(Trim(SAP_to_Trans.ZCAT_UDATE)) = 0 then StringToTimeStamp('19000101',"%yyyy%mm%dd") else StringToTimeStamp(Trim(SAP_to_Trans.ZCAT_UDATE):Trim(SAP_to_Trans.ZCAT_UTIME),"%yyyy%mm%dd%hh%nn%ss")
Can somebody help me out with this.
Cheers!!!!