Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Whats Wrong With This Syntax?
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Whats Wrong With This Syntax?
Miscellaneous
Thread ID:
01065581
Message ID:
01065581
Views:
46
SQL Query Analyzer reports "Syntax error converting datetime from character string."

It doesn't like the empty datetimes. How do I insert an empty datetime?
insert into commits 
  (donedatetime, invdate, duedate, fromdate, todate, invoiceid, oldetype, discnotes,
   batchid, adjamt, isci, dayofwk, userid, refnum, statname, status ) 
 values ('07/30/2004 10:54:45', '06/01/2004 00:00:00', '07/01/2004 00:00:00', 
         '  /  /       :  :  ', '  /  /       :  :  ', '1927-01             ', 
         ' ', '', 'AO0NBDRX', '0', '               ', '  ', 'JVILLAGOMEZ         ', 
         '4003978', 'WUPW      ', '1')
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform