OraFAQ Forum: Forms » how to convert a item's datatype dynamicly?

Home » Developer & Programmer » Forms » how to convert a item's datatype dynamicly?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to convert a item's datatype dynamicly? [message #81891]

Sun, 30 March 2003 20:49

zhangrui
Messages: 37
Registered: March 2003

Member

hi,all
I want to convert a item's datatype in program.e.g:
'item1' is a char datatype ,in somewhere I want to change its datatype to date.How can I do that?
ths!
best regard

Report message to a moderator

Re: how to convert a item's datatype dynamicly? [message #81896 is a reply to message #81891]

Sun, 30 March 2003 23:23

utsav
Messages: 94
Registered: March 2003

Member

Hi,

Well if u want to convert char to date use to_date,
if u want to convert date to char use to_char
if u want to convert number to char use nothing(implicit),
if u want to convert char to number use nothing.

well for any other conversions try in the conversion functions help.

In case of problem do let me know.
utsav.

Report message to a moderator