OraFAQ Forum: Forms » Date Function that tell given date is valid format or not

Home » Developer & Programmer » Forms » Date Function that tell given date is valid format or not

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

Date Function that tell given date is valid format or not [message #300570]

Sat, 16 February 2008 03:03

azamkhan
Messages: 557
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

Report message to a moderator

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

sasipalarivattom
Messages: 121
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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What is wrong with the default edit handling associated with a 'date' field?

David

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 08:24:42 CDT 2024