SQL server will accept datetime strings in more or less any sensible format for the purposes of comparison.<BR><BR>select * from employee<BR>where hire_date='1993-08-19'<BR><BR>select * from ...

I just added a field, 'ExportDate' to a table (AYP) in my MS SQL 2000 database. Since I added the field to an existing table, the values for 'ExportDate' in all records is <null>.<P>What I need to ...

Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types.