How do i format Date string??? 1

[anumala28]

Hi,

I need to format date i.e in string format.

'2003/12/30' this string i need to format as YYYYMM

Please give soluation ASAP

Thanks,
Sri

 

[canhe]

Hi,

There is a couple of ways, You can use the following (This is sql for informix). You can use the Year and Month function in Impromptu's function tab:

Year,(date,'%Y%m%d') ||'/' || month(date,'%Y%m%d')
or
substring (TO_CHAR(DATETIME( 2003/07/02 ) YEAR TO DAY ,'%Y-%m-%d')
from 0 for 8)

canhe

 

[Coglerner]

First Convert the '2003/12/30' to Date by using string to date. Then use Year function to get YYYY and Month to get MM.

Year(date)+Mon(Date).Hope this would be helpful.

Regards