OraFAQ Forum: MySQL » Date validation in mysql

Home » Open Source » MySQL » Date validation in mysql

Mon, 17 September 2012 06:53

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

Hi All,

We need to create the custom function to pass the parameter is date.if it is valid return 1 else 0
it should return 1

select is_date('2012-09-17');

it should return 0

select is_date('2012-79-17');

Thanks,
Murali

Mon, 17 September 2012 07:06

Michel Cadot
Messages: 54223
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Mon, 17 September 2012 08:03

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

Thanks Micheal.. i got the result..

Mon, 17 September 2012 08:19

Michel Cadot
Messages: 54223
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So post it.

Regards
Michel

Tue, 18 September 2012 03:12

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

select date_format(date_sub(date_add('2012/09/47', interval 1 day), interval 1 day),'%Y%m%d')  = date_format('2012/09/47','%Y%m%d');

Previous Topic:	File data without -INFILE
Next Topic:	MySQL data model

Goto Forum:

]

Current Time: Thu May 23 15:09:59 CDT 2013

Total time taken to generate the page: 0.82657 seconds