I'm trying to import a large amount of data into a flat table using CSV. During the import BigQuery reports:

```
- File: 0 / Line:6659 / Field:11: Could not parse '' as a timestamp

```

In the schema I have 2 timestamps: fields 4 and 11 . Both are nullable. For the second timestamp the row entry on field 11 is indeed null.

Is it supposed to work like this or do I need to send it as "0" ?
['https://Stackoverflow.com/questions/20621868', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/3108981/']
Note the difference between a null value and an empty string. Line 6659 copied above has empty strings, but not nulls.

To reproduce, I created a table with this schema:

```
[{"name":"a","type":"TIMESTAMP","mode":"NULLABLE"},
 {"name":"b","type":"TIMESTAMP","mode":"NULLABLE"}]

```

Then uploaded this file to it:

```
"",""

```

Where I got this error:

```
File: 0 / Line:1 / Field:1, Could not parse '' as a timestamp

```

But if I upload this file:

```
,

```

Everything works fine, as there are 2 nulls surrounding that comma.

You can either transform all your files, getting rid of the empty strings, or import those columns to BigQuery as string, and run an ETL from string to timestamp inside BigQuery.
I had similar problem like this 

The error was 

```
- File: 2 / Line:9940 / Field:13: Day 0-0-0 does not exist for
 timestamp: 0000-00-00 00:00:00

"9718470";"2769586jfghjkdf";"2015-08-03 15:57:28";"2015-08-03 16:10:10";"479";"128833308";"May 2015";"1461782";"ab_20150616";"1130567689";"69466";"emailid@hotmail.com";"0000-00-00 00:00:00";"2015-08-03 23:53:44"

```

The 13th field was TIMESTAMP in my BigQuery Schema, and I was sending "0000-00-00 00:00:00" .
Big Query doesn't accept "0000-00-00 00:00:00".

To solve this problem I send

```
"9718470";"2769586jfghjkdf";"2015-08-03 15:57:28";"2015-08-03 16:10:10";"479";"128833308";"May 2015";"1461782";"ab_20150616";"1130567689";"69466";"emailid@hotmail.com";;"2015-08-03 23:53:44"   

```

In short you have to send **"someValue";;"someOtherValue"** instead of 
"someValue";"0000-00-00 00:00:00";"someOtherValue or "someValue";"";"someOtherValue

Please note , I am using ; as delimiter.