Get fields that are datetime from sql server

[jean_5]

I have the following table User in my database

Name(Varchar) DateOfBirth(datetime) Age(int)

Name(Varchar) | DateOfBirth(datetime) | Age(int)
John          | 2014-12-20 23:59:59   | 0
Mary          | 2014-12-20 23:59:59   | 1

How can i verify throught javascript if the field DateOfBirth of the table User of the database z is of type datetime?

[djjeavons]

Hi

Why would you need to do this? If your database table states that DateOfBirth is a datetime field then it will be a datetime value. Are you looking to validate input data before saving it to the database?

Anyhow, I am not an expert in Javascript but I don't believe there is a built in date validator like isDate for example. But a quick search of google showed many results for creating your own javascript function. Also, there is a jQuery Validator plugin that may be do what you need (jQuery Validation Plugin).

Another option (not recommended) would be to use regular expressions to ensure that the input pattern is correct (BUT this would not be a true test as it would not handle leap years).

[jean_5]

I saw this jQuery Validation Plugin. But it does not work for sql server. But thanks for the answer. Helped me a lot