Home » Developer & Programmer » Forms » date format
date format [message #607348] Wed, 05 February 2014 01:47 Go to next message
mist598
Messages: 904
Registered: February 2013
Location: Hyderabad
Senior Member
Hi all,

I am trying to pass date format as 12-jan-2014(dd-mon-yyyy) but it is not taken this format, by default the date format is DD-MON-YYYY, but i want to pass lower format also how it is possible?

Thank You
Re: date format [message #607350 is a reply to message #607348] Wed, 05 February 2014 02:00 Go to previous messageGo to next message
mist598
Messages: 904
Registered: February 2013
Location: Hyderabad
Senior Member
And i checked at the date column properties in Functional-->Case Restriction as Mixed , means upper & lower, then why it is not taken date format as dd-mon-yyyy(lower format) suggestions please.
Re: date format [message #607364 is a reply to message #607350] Wed, 05 February 2014 02:57 Go to previous messageGo to next message
cookiemonster
Messages: 10904
Registered: September 2008
Location: Rainy Manchester
Senior Member
I assume you're talking about a datablock item of datatype date?
Why does it matter which case it displays in?
Re: date format [message #607367 is a reply to message #607364] Wed, 05 February 2014 03:05 Go to previous messageGo to next message
mist598
Messages: 904
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
I assume you're talking about a datablock item of datatype date?


Yes.I have CREATED_DATE_LOW, CREATED_DATE_HIGH is the non-databased items & i want to pass both upper&lower

Quote:
Why does it matter which case it displays in?


If i pass date in the upper case only.
Re: date format [message #607368 is a reply to message #607348] Wed, 05 February 2014 03:13 Go to previous messageGo to next message
mist598
Messages: 904
Registered: February 2013
Location: Hyderabad
Senior Member
Hi cookiemonster,
Please find the below code.
x_date_low := :BLOCKNAME.created_date_low; 

    x_date_high := :BLOCKNAME.created_date_high; 


    v_req_id := fnd_request.Submit_request(v_application, 
                                           x_date_low,
                                           x_date_high, 
                                           .
                                           .
                                           );


Thank You
Re: date format [message #607369 is a reply to message #607368] Wed, 05 February 2014 03:21 Go to previous messageGo to next message
cookiemonster
Messages: 10904
Registered: September 2008
Location: Rainy Manchester
Senior Member
I see nothing there that explains why you care what case the date is displayed in.
Re: date format [message #607370 is a reply to message #607369] Wed, 05 February 2014 03:24 Go to previous messageGo to next message
mist598
Messages: 904
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
I see nothing there that explains why you care what case the date is displayed in.


And i checked at the date column properties in Functional-->Case Restriction as Mixed , means upper & lower, then why it is not taken date format as dd-mon-yyyy(lower format) as well as upper case.That is doubt only.. Smile
Re: date format [message #607373 is a reply to message #607370] Wed, 05 February 2014 03:37 Go to previous messageGo to next message
cookiemonster
Messages: 10904
Registered: September 2008
Location: Rainy Manchester
Senior Member
because it's a date. You can enter it in any case you like but oracle doesn't store it in that case, or any case, it's stored as a set of integers.
And since oracle doesn't store the case, it's not going to display it.
Re: date format [message #607375 is a reply to message #607373] Wed, 05 February 2014 03:44 Go to previous message
mist598
Messages: 904
Registered: February 2013
Location: Hyderabad
Senior Member
Ok Thank You cookiemonster.. Smile
Previous Topic: How to delete Current Cursor Record Using a button
Next Topic: ERROR IN ORACLE FORMS AND REPORTS
Goto Forum:
  


Current Time: Fri Aug 22 04:56:09 CDT 2014

Total time taken to generate the page: 0.11350 seconds