Passing a NULL value into a date time field 
Author Message
 Passing a NULL value into a date time field

I can only pass ' ' to SQL and this creates the default value of 01/01/1900
Is there a way to pass NULL into a date time field (SQL 7.0)?
Thanks in advanced

Scott clarke



Wed, 25 Jun 2003 04:28:35 GMT  
 Passing a NULL value into a date time field
What happens if you use Null?

--

Doug Steele, Microsoft Access MVP
Beer, Wine and Database Programming. What could be better?
Visit "Doug Steele's Beer and Programming Emporium"
http://I.Am/DougSteele/


I can only pass ' ' to SQL and this creates the default value of 01/01/1900
Is there a way to pass NULL into a date time field (SQL 7.0)?
Thanks in advanced

Scott clarke



Wed, 25 Jun 2003 05:10:43 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Null date values in Date/Time fields in Access DB

2. Populating Null value in SQL Date/Time field

3. Passing Null Date values to sql server stored proc

4. adodb connection to excel: recordset.fields(i).value=null for fields with numeric value

5. adodb connection to excel: recordset.fields(i).value=null for fields with numeric value

6. adodb connection to excel: recordset.fields(i).value=null for fields with numeric value

7. Null values in Date Time Picker

8. Date Time Picker and null value

9. Access date/time null values

10. Access date/time null values

11. NULL VALUES IN DATE FIELD - TYPE MISMATCH ERROR

12. How to give Date fields null values?

 

 
Powered by phpBB® Forum Software