Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 17,511 of 19,505    |
|    Ed Murphy to --CELKO--    |
|    Re: MSSQL Default Date Value    |
|    28 May 09 23:44:49    |
      134e155e       From: emurphy42@socal.rr.com              --CELKO-- wrote:              > 2) Rows are nothing like records, and columns are not like fields.       > Among MANY differences, columns are NULL-able and have a single data       > type. In SQL we have temporal data types. There is no such thing as       > the DATE "blank"!! That is a string. Think about it -- can you name       > the King of England on the date "blank"??              He mentions smalldatetime and NULL in the first sentence of the original       message, so clearly he understands what the column should contain. Now       granted the terminology is a bit sloppy, and may or may not indicate       that he's implicitly casting strings to some date type.              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca