home bbs files messages ]

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