Check valid datetime in sql

Question

@date varchar(50)='14-9-2017-18-10-58' How to check if @date is valid Datetime in Sql server

Gautam Parmar · Answer

Hi You may achieve this using ISDATE function. IF ISDATE( '2009-05-12 10:19:41.177' ) = 1 PRINT 'VALID' ELSE PRINT 'INVALID' ;

Dipika · Answer

@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

Zakir Ahamed · Answer

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

Zakir Ahamed · Answer

Declare Date Like this: @Appointment_date nvarchar(30)=null and Pass in sp ex: select Appoinmnetdate from tablename where a.Appointment_date=@Appointment_date