You need to sign in to do that
Don't have an account?
bytor1971
Formatting a Date in SOQL
I am attempting to format a datetime object queried in an SOQL statement. However, the format method of the dateTime object is not accepted and I receive an unexpected token error and the token is the open parenthesis of the following excerpt.
select Start_Time__c.format('DD-MMM-YYYY')
Am I not invoking the method of the dateTime object correctly?
Thanks
JimRae
You can't reformat the field directly in the query. You will need to do the formatting to the results instead.
bytor1971
That's what I feared. I was hoping that the O in SOQL stood for object. ;-)