Loading

DATE Function Returns NULL in Google Big Query

Publiceringsdatum: Feb 26, 2025
Beskrivning

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.

Lösning
Use "-" instead of "/" as a separator. For example, DATE("1970-01-01"). 
Ytterligare resurser

Knowledge-artikelnummer

001473283

 
Laddar
Salesforce Help | Article