Book Image

Getting Started with SOQL

By : Magulan D
Book Image

Getting Started with SOQL

By: Magulan D

Overview of this book

<p>This practical guide will tell you everything you need to know about SOQL statements. You will learn the optimum way to write complex SOQL statements with this easy-to-understand guide. Beginning with basic SOQL statements, you will progress quickly onto more advanced statements, such as how to filter multiselect picklist values to escape sequences.</p> <p>This book will teach you how to sort records with more than one field, sorting with more than one field–one in ascending order and another field in descending order—and sorting null records in the first or in the last. You will learn about all the features provided while you are writing SOQL statements. This book will make you a SOQL expert by teaching you how to write SOQL statements in an optimized and effective way.</p>
Table of Contents (14 chapters)
Getting Started with SOQL
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

The date formats


When querying the records using the date field or the date and time field in the SOQL statement, the date formats should be followed. The following table shows the list of date formats that can be used in the SOQL statements:

Format

Examples

YYYY-MM-DD

1999-01-01

YYYY-MM-DDThh:mm:ss+hh:mm

1999-01-01T23:01:01+01:00

YYYY-MM-DDThh:mm:ss-hh:mm

1999-01-01T23:01:01-08:00

YYYY-MM-DDThh:mm:ssZ

1999-01-01T23:01:01Z