Convert date to charactor

deva · Post by **deva** » Wed Jun 18, 2008 8:38 am

Hi ,
I want to convert date or time stamp in to charactor . In server job we don't have functionality like DateToString().

Required output date is Char(8) yyyymmdd.

ArndW · Post by **ArndW** » Wed Jun 18, 2008 8:40 am

In server jobs you have a much more powerful and versatile set of functions, ICONV() and OCONV() which can pretty much convert any date type you can imagine. You've specified the output, but what is the input format?

deva · Post by **deva** » Wed Jun 18, 2008 9:06 am

Can you please give me the formate how to convert the date into charactor.

example 2000/09/23 into 20000923.

Thanks in advance

chulett · Post by **chulett** » Wed Jun 18, 2008 9:14 am

Code: Select all

Convert("/","",YourField)