Loading

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

Fecha de publicación: Dec 2, 2025
Descripción

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).

Solución

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))
Número del artículo de conocimiento

001870641

 
Cargando
Salesforce Help | Article