Loading

DateTime Format In SQL

DateTime Format In SQL

10y1.2kSQL

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Riddhi Valecha10y ago
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)
0
Tusharika T10y ago
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
0
Vipan Sharma10y ago
not possible :(
0
Krishna Rajput Singh10y ago
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
0

Amit Kumar Singh

Amit Kumar Singh10y ago

1.
  set dateformat dmy  

  select CAST('03/28/2011 18:03:40' AS DATETIME)

2.
  CAST(CONVERT(VARCHAR,GETDATE(),101) AS DATETIME)

0

10y ago
Not Possible.
0