Convert datetime using iconv, oconv

DSRajesh · Post by **DSRajesh** » Fri Oct 11, 2013 2:51 am

Dear All

I am getting the datatime as YYYYMMDD_HHMMSS when using DSJ.JOBLASTTIMESTAMP in the routine.

I need to convert YYYYMMDD_HHMMSS to YYYY-MM-DD HH:MM:SS using iconv and oconv .

Can anyone please suggest me how to do this.

ArndW · Post by **ArndW** » Fri Oct 11, 2013 3:21 am

There is no need to use ICONV() and OCONV() here, a simple string function works more efficiently:

Code: Select all

LastTS[1,4]:'-':LastTS[5,2]:'-':LastTS[7,2]:' ':LastTS[10,2]:':':LastTS[12,2]:':':LastTS[14,2]

DSRajesh · Post by **DSRajesh** » Fri Oct 11, 2013 3:29 am

Hi ArndW,

I am unable to see the full content.

Request you to please give the code

ArndW · Post by **ArndW** » Fri Oct 11, 2013 4:22 am

There should be enough visible to show you how to go about building the string correctly. The site is kept running by volunteers and by premium memberships and it would seem that the user ID you are using has let this lapse and for this reason the whole message is not visible to you.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 11, 2013 4:45 am

I think that the substringing approach suggested by Arnd is probably more efficient, but wonder how close the following construction would be.

Code: Select all

Fmt(Convert("_","",LastTS),"L####-##-## ##:##:##")

DSRajesh · Post by **DSRajesh** » Fri Oct 11, 2013 7:53 pm

Dear Ray,

Could you please give me code with date column as an example with the above timestamp format.

ray.wurlod · Post by **ray.wurlod** » Sat Oct 12, 2013 2:31 pm

The code is in my response earlier.