javascript date validation dd mm yyyy regular expression

Using these types, you can describe any data structures. These types exist in most programming languages, though they may go by different names. OpenAPI defines the following basic types:

The data type of a schema is defined by the type keyword, for example, type: string. Using 2-digit years is even more stupid than using a string when a DATE is appropriate.OAS 3 This guide is for OpenAPI 3.0. I didn't mean to say anything like that, and I don't think anyone in this thread has suggested using 2-digit years. I apologize if I said that 2-digit years were a good idea. Again, this has nothing to do with the problem I was discussing. Even if you're using a DATE datatype, as everyone should always do, it's possible to enter '05/04' when you really mean to enter '04/05'. Someone can enter '05/04' when they mean to enter '04/05'. Of course data entry errors are always possible. I was talking about how we can use regular expressions to see if a string represents a date in 'MM/DD/YYYY' format. And even worse, if the string is only using two digit years, you have no reliable way of knowing anything about '05/04/11' Any of the three elements are valid for day, month, or year. But you really have no way of knowing if '' is May 4 or April 5. I don't see how we could check for leap years, though, as long as the regular expression has to fit in a VARCHAR2.īut even that assumes that your string is actually a consistent format that meets your assumptions of 'mm/dd/yyyy'. With even more work, we could check that 'DD' is never '31' for April, June, etc., and that it's not '30' for February. With a little more more work, we could make sure that 'MM' was between '01' and '12', and that 'DD' was always between '01' and '31'. Using just a regular expression, we could easily check that the string is in 'MM/DD/YYYY' format, though 'DD' might be '99'. We'd have to combine a regular expression (or multiple exprdssions) with something else. Using only a regular expression (any REGEXP function now available in Oracle), we can't check for all possible mistakes. I agree but let's say this is a purely academic question, not something we plan to use in actual Production code. Oh, and by the way - I still stand by my statement that you cannot validate a string is a valid date with a regular expression Make use of the tools you have - no need to reinvent the wheel.

1.7K Training / Learning / Certification.

165.3K Java EE (Java Enterprise Edition).

7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.

Javascript date validation dd mm yyyy regular expression