Home » Developer & Programmer » Forms » Date format of get_item_property(item1, database_value)
Date format of get_item_property(item1, database_value) [message #329993] Fri, 27 June 2008 04:16 Go to next message
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!
Re: Date format of get_item_property(item1, database_value) [message #330296 is a reply to message #329993] Sat, 28 June 2008 23:49 Go to previous messageGo to next message
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);
Re: Date format of get_item_property(item1, database_value) [message #330304 is a reply to message #330296] Sun, 29 June 2008 03:53 Go to previous messageGo to next message
Frank
Messages: 7880
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?
Re: Date format of get_item_property(item1, database_value) [message #331546 is a reply to message #329993] Thu, 03 July 2008 22:22 Go to previous message
raywong9i
Messages: 40
Registered: April 2008
Member
Actually, I change the data format by set_application_property(BUILTIN_DATE_FORMAT)

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


Current Time: Sun Dec 11 02:43:17 CST 2016

Total time taken to generate the page: 0.09184 seconds