OraFAQ Forum: Forms » Date format of get_item_property(item1, database_value)

Home » Developer & Programmer » Forms » Date format of get_item_property(item1, database_value)

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

Date format of get_item_property(item1, database_value) [message #329993]

Fri, 27 June 2008 04:16

raywong9i
Messages: 40
Registered: April 2008

Member

Hi all,

I have a form using get_item_property(item1, database_value),
however when I upgraded to 10g, I have found problem when using this on DATE field.

The get_item_property(item1, database_value)
will give me a varchar2 string of "02-JAN-2008", do you know what is the date format are the system using for this conversion?

Are the system using BUILTIN_DATE_FORMAT, PLSQL_DATE_FORMAT,
USER_DATE_FORMAT, USER_NLS_DATE_FORMAT or others ?

Thanks!

Report message to a moderator

Re: Date format of get_item_property(item1, database_value) [message #330296 is a reply to message #329993]

Sat, 28 June 2008 23:49

savlon99
Messages: 22
Registered: June 2008
Location: Bangladesh

Junior Member

if u wish thn u can change all these parameter by

SQL> alter system set (Parameter name);

Report message to a moderator

Re: Date format of get_item_property(item1, database_value) [message #330304 is a reply to message #330296]

Sun, 29 June 2008 03:53

Frank
Messages: 7901
Registered: March 2000

Senior Member

Bad idea to alter your system for this!
Don't you think you might run the risk of destroying the rest of your applications?

Report message to a moderator

Re: Date format of get_item_property(item1, database_value) [message #331546 is a reply to message #329993]

Thu, 03 July 2008 22:22

raywong9i
Messages: 40
Registered: April 2008

Member

Actually, I change the data format by set_application_property(BUILTIN_DATE_FORMAT)

Thanks!

Report message to a moderator

Previous Topic:	where can i find IFRUN60.exe ?
Next Topic:	Oracle Forms and Reports Server Configuration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 08:07:09 CST 2025