Loading

Data 360: Adding a DateTime filter to an SQL WHERE Clause in Query Editor

Data pubblicazione: Dec 2, 2025
Descrizione

Create Queries in Query Editor outlines how to run SQL SELECT queries on data in Data 360 objects. When configuring a query you may wish to run a query to SELECT records based on a value in a DateTime field. If you use the wrong format, the query will return an error (e.g. ANSI_SQL_API_BAD_REQUEST).

Risoluzione

To filter on a DateTime field in Query Editor, use the following format in the WHERE clause:

select * from ssot__Individual__dlm WHERE ssot__LastModifiedDate__c > cast('2020-06-10 00:00:00.000000' as timestamp(1))
Numero articolo Knowledge

001870641

 
Caricamento
Salesforce Help | Article