Home » Developer & Programmer » Forms » Date Function that tell given date is valid format or not
Date Function that tell given date is valid format or not [message #300570] Sat, 16 February 2008 03:03 Go to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear Friends,

I am looking for a function that can tell is the given value is a valid date or a valid format of date.

For example,

if I give date = A or Date = 01-Jan-5a or simple thing like this then it return me a value that can tell me that it is not a valid date.

Regards,
Azam Khan
Re: Date Function that tell given date is valid format or not [message #300572 is a reply to message #300570] Sat, 16 February 2008 03:21 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Hi Dear Khan,

I think this bit of code may help you..

This iss not an answer for your question but it will light something.. na?

Let me know if it works.

declare
	vd date;
begin
	select to_date('5a','dd-mon-yyyy') into vd from dual;
exception when others then
	message('Not a valid date');
end;


Regards
Sasi..

[Updated on: Sat, 16 February 2008 03:21]

Report message to a moderator

Re: Date Function that tell given date is valid format or not [message #300724 is a reply to message #300570] Sun, 17 February 2008 23:31 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What is wrong with the default edit handling associated with a 'date' field?

David
Previous Topic: How to Play Video in Developer 10g Form
Next Topic: Call Menu
Goto Forum:
  


Current Time: Sun Dec 11 00:36:43 CST 2016

Total time taken to generate the page: 0.03900 seconds