Check valid datetime in sql

Hi,

You may achieve this using ISDATE function.

John9y ago

@date varchar(50)='14-9-2017-18-10-58'

I need to replace the last 2 '-' character with ':'(colon) and then the last 3rd with space

Like this and then i can convert and check

select convert(datetime,'4-9-2017 18:10:58',103) as d

But i m not able to replace the last 2 and 3rd character in sql

Use This Url:

https://stackoverflow.com/questions/42024519/how-to-validate-time-in-sql-server

http://codebetter.com/petervanooijen/2008/08/21/valid-date-time-values-in-sql-server-sqldatetime-vs-datetime/

https://docs.microsoft.com/en-us/sql/t-sql/data-types/datetime-transact-sql

https://stackoverflow.com/questions/877434/validate-datetime-string-in-sql-server-2005

Declare Date Like this:

@Appointment_date nvarchar(30)=null

and Pass in sp

ex:

select Appoinmnetdate from tablename

where a.Appointment_date=@Appointment_date