Loading

DATE Function Returns NULL in Google Big Query

Julkaisupäivä: Feb 26, 2025
Kuvaus

When using Google Big Query, the following type of DATE function DATE("1/1/1970") returns NULL. 
 

Cause:

Google BigQuery expects "YYYY-MM-DD" format as a date format.

Ratkaisu
Use "-" instead of "/" as a separator. For example, DATE("1970-01-01"). 
Lisäresurssit

Knowledge-artikkelin numero

001473283

 
Ladataan
Salesforce Help | Article