OraFAQ Forum: Forms » date format

Home » Developer & Programmer » Forms » date format

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

date format [message #607348]

Wed, 05 February 2014 01:47

mist598
Messages: 1195
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

Report message to a moderator

Re: date format [message #607350 is a reply to message #607348]

Wed, 05 February 2014 02:00

mist598
Messages: 1195
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.

Report message to a moderator

Re: date format [message #607364 is a reply to message #607350]

Wed, 05 February 2014 02:57

cookiemonster
Messages: 13923
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?

Report message to a moderator

Re: date format [message #607367 is a reply to message #607364]

Wed, 05 February 2014 03:05

mist598
Messages: 1195
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.

Report message to a moderator

Re: date format [message #607368 is a reply to message #607348]

Wed, 05 February 2014 03:13

mist598
Messages: 1195
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

Report message to a moderator

Re: date format [message #607369 is a reply to message #607368]

Wed, 05 February 2014 03:21

cookiemonster
Messages: 13923
Registered: September 2008
Location: Rainy Manchester

Senior Member

I see nothing there that explains why you care what case the date is displayed in.

Report message to a moderator

Re: date format [message #607370 is a reply to message #607369]

Wed, 05 February 2014 03:24

mist598
Messages: 1195
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

Report message to a moderator

Re: date format [message #607373 is a reply to message #607370]

Wed, 05 February 2014 03:37

cookiemonster
Messages: 13923
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.

Report message to a moderator

Re: date format [message #607375 is a reply to message #607373]

Wed, 05 February 2014 03:44

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Ok Thank You cookiemonster.. Smile

Report message to a moderator

Previous Topic:	How to delete Current Cursor Record Using a button
Next Topic:	ERROR IN ORACLE FORMS AND REPORTS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 23:16:06 CDT 2024