OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » date (oracle 10g windows)

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

date [message #304450]

Wed, 05 March 2008 04:22

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

i want to display date in dd mm yyyy format in three textboxes.
i choose day mm yyyy indvidualy but store inthe database single.
anybody knows the solution send immediately.

Report message to a moderator

Re: date [message #304455 is a reply to message #304450]

Wed, 05 March 2008 05:14

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

"Immediately" doesn't mean much on a forum.

Even if it does, I don't understand what you are talking about. Date format mask is self understandable, I believe. But what do you mean by "individually" and "storing single into the database"?

Report message to a moderator

Re: date [message #304457 is a reply to message #304450]

Wed, 05 March 2008 05:14

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Dear I think that you have to do this

first assign your split date in to a variable

DECLARE
v_date DATE;

BEGIN

v_date := TO_DATE (Block.v_day||Block.v_mon||Block.v_year, 'DDMONYYYY');

END;

Then use this v_date in your insert.

Regards,
Azam Khan

Report message to a moderator

Previous Topic:	Concat
Next Topic:	auto generating a serial number on a form's multi record block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 03:07:27 CST 2025