Converting the week format

[Former Member]

Hi All,

I created View using the table and the view contains data with weekly like

1200 01/09

1300 02/09

-

---

-

---

-

---

4500 52/09

I exported the view in to the universe and it is with char format. I would like to convert that into date format with weekly...

ie. I would like to see the same format which I am having in View.

Can any body please help me.

Thanks

Muvva

[Former Member]

Hi,

Which database are you using?

Didier

[Former Member]

Thaks for the reply

Oracle 10g

[Former Member]

Hi,

In Oracle you can't convert into date a string containing a week number.

Didier

[Former Member]

Do you have any idea to make it as weekly other than the view?

thanks

Muvva