Home » Developer & Programmer » Forms » date (oracle 10g windows)
date [message #304450] Wed, 05 March 2008 04:22 Go to next message
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.
Re: date [message #304455 is a reply to message #304450] Wed, 05 March 2008 05:14 Go to previous messageGo to next message
Littlefoot
Messages: 20895
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"?
Re: date [message #304457 is a reply to message #304450] Wed, 05 March 2008 05:14 Go to previous message
azamkhan
Messages: 548
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
Previous Topic: Concat
Next Topic: auto generating a serial number on a form's multi record block
Goto Forum:
  


Current Time: Tue Dec 06 00:15:57 CST 2016

Total time taken to generate the page: 0.08801 seconds