displaying yyyymmm date format as dd/mm/yy

tsatya · #1 (**permalink**) 12-18-07, 02:50

Hi,

I've a column (datatype is char) which stores date as yyyymmm.
I want it to display as dd/mm/yyyy.
I'm using 2000i.

Can anybody help me?

Rgds,
Satya

mirtheil · #2 (**permalink**) 12-18-07, 08:13

You would need to parse the date after the data is returned and then display it however you want.
If you want more specific information, you need to give us more. Things like how are you retrieving the date, (Btrieve vs SQL), what programming environment, and what you have tried.

yy17616433 · #3 (**permalink**) 01-09-08, 12:28

Once bitten!twice shy!