Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
kt
Yak Posting Veteran
88 Posts |
Posted - 2013-03-18 : 10:18:47
|
what is 1753-01-01 and 1953-01-01 dates in sql? is that for empty date?thanks |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-03-18 : 10:29:45
|
for datetime type column, the minimum allowed date is 1753-01-01Execute separately...1)DECLARE @date DATETIME = '1753-01-01'SELECT @date2)DECLARE @date DATETIME = '1752-12-31'SELECT @date3)DECLARE @date DATETIME = '1752-31-12'SELECT @date--Chandu |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2013-03-18 : 10:32:56
|
Just something to keep in mind: I have noticed sometimes that when you leave a date column empty sql server converts into 1900-01-01.--------------------------Joins are what RDBMS's do for a living |
|
|
kt
Yak Posting Veteran
88 Posts |
Posted - 2013-03-18 : 10:41:38
|
so there are there diffrent days that SQL converts into when date column empty ?1753-01-01,1953-01-01 and 1900-01-01 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-18 : 12:53:20
|
depends on logic you use to convert those nulls. if you convert to 0 then it corresponds to datevalue of 1900-01-01------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
kt
Yak Posting Veteran
88 Posts |
Posted - 2013-03-18 : 17:36:42
|
i am inherited the database from previous developers. I think they have it set “ ” and some 0. I have at least two different date in the table1753-01-01 and 1953-01-01, don't know if any more out there. My question is how can i query only the records for those date ?select....from...where year(dateAdded in ('1753', '1953') or what if i don't know if it has any other date there that sql automatice coverted into? |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2013-03-18 : 19:27:25
|
Bonus question: Why is '1753-01-01' the starting point for the datetime data type? It seems a rather odd point of origin.=================================================There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-19 : 02:02:52
|
quote: Originally posted by Bustaz Kool Bonus question: Why is '1753-01-01' the starting point for the datetime data type? It seems a rather odd point of origin.=================================================There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber
see similar discussion herehttp://stackoverflow.com/questions/3310569/what-is-the-significance-of-1-1-1753-in-sql-server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|