DateTime Format In SQL

Question

pls Resolve this Issue.. DECLARE @Stdate varchar(20) SET @Stdate = CONVERT(VARCHAR(20), '31/03/2016', 111) SELECT (DATEADD(MONTH, 12 , @Stdate)) AS EndDate Error Msg 242, Level 16, State 3, Line 34 The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Riddhi Valecha · Answer

Hi...Replace your column name with getdate() - See if this helps.... select convert(varchar, getdate(), 101) select convert(varchar, getdate(), 102) select convert(varchar, getdate(), 103) select convert(varchar, getdate(), 104) select convert(varchar, getdate(), 105) select convert(varchar, getdate(), 106) select convert(varchar, getdate(), 107) select convert(varchar, getdate(), 108) select convert(varchar, getdate(), 109) select convert(varchar, getdate(), 110) select convert(varchar, getdate(), 111) select convert(varchar, getdate(), 112) select convert(varchar, getdate(), 113)

Tusharika T · Answer

HII Pass date in MM/DD/YYYY DECLARE @Stdate varchar(20) SET @Stdate = CONVERT(VARCHAR, '03/31/2016',104) SELECT CONVERT(VARCHAR,(DATEADD(MONTH, 12 , @Stdate)),103) AS EndDate

Vipan Sharma · Answer

not possible :(

Krishna Rajput Singh · Answer

Hello Ronak Patel thanks for writing below links i hope helpful for you..:) SQL Server comes with the following data types for storing a date or a date/time value in the database: DATE - format YYYY-MM-DD . DATETIME - format: YYYY-MM-DD HH :MI:SS. SMALLDATETIME - format: YYYY-MM-DD HH :MI:SS. http://www.w3schools.com/sql/sql_dates.asp if find helpful answer mark as correct

Amit Kumar Singh · Answer

1. set dateformat dmy select CAST('03/28/2011 18:03:40' AS DATETIME) 2. CAST(CONVERT(VARCHAR,GETDATE(),101) AS DATETIME)

Ronak Patel · Answer

Not Possible.