Apex Code Development You need to sign in to do that
Don't have an account?
jontk Date Time format error
Page 32 of the 6.0 API doc says that 2005-05-05T12:00:00 should be a valid date and time format but I get a malformed query error when I try this. Am I missing something obvious?
Thanks in advance.
Jon
select id,date__c from Contact where date__c = 2005-05-05T12:00:00ng>
ns1:MALFORMED_QUERY
MALFORMED_QUERY:
where date__c = 2005-05-05T12:00:00
^
ERROR at Row:1:Column:67
unexpected char: 0x?F
MALFORMED_QUERY
where date__c = 2005-05-05T12:00:00
^
ERROR at Row:1:Column:67
unexpected char: 0x?F
1
67
Thanks in advance.
Jon
select id,date__c from Contact where date__c = 2005-05-05T12:00:00ng>
ns1:MALFORMED_QUERY
MALFORMED_QUERY:
where date__c = 2005-05-05T12:00:00
^
ERROR at Row:1:Column:67
unexpected char: 0x?F
MALFORMED_QUERY
where date__c = 2005-05-05T12:00:00
^
ERROR at Row:1:Column:67
unexpected char: 0x?F
1
67
The docs are wrong (i'll get that fixed), you have to use one of the formats that include a TZ offset.