UDAY convert question

[EBee]

I have a oracle database with a number(12) type field that is storing date this way 1020131 as a YYYMMDD format

how can i change this to 01/31/02 format in Access97 query

thanks
erwin

 

[tomschafer]

You can use...

select
format(FieldName, "Short Date&quot
from
TableName

or

select
format(FieldName, "mm/dd/yy&quot
from
TableName

 

[EBee]

I tried what you suggested and did not work, the field is a number type and the format is YYYMMDD.

what else can i try. . how about to_char. . does this work in access query

erwin

 

[tomschafer]

No but the function in Access to convert it to text would be CStr, to date would be CDate- I'd try CDate first. Sorry I've never played with Oracle a little Informix-Which has a to_char and to_date function.