Sign Up ›
  • Doyeli Ray 5
  • NEWBIE
  • 0 Points
  • Member since 2015
  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
2 replies

I need to use Today's date in a format like 2016-03-22T03:44:34.000-07:00 in a where clause in a query. Can you please help how to format this

I need to use Today's date in a format like 2016-03-22T03:44:34.000-07:00 in a where clause in a query. Can you please help how to format this.
like 

SELECT id,name,SubscriptionId,createdDate FROM Amendment where createdDate = today

and today needs to be in this format, e.g.
2016-03-22T03:44:34.000-07:00

So, if I get system.today(); I need your help how to format that as I mentioned above.

Thank you
2 replies

I need to use Today's date in a format like 2016-03-22T03:44:34.000-07:00 in a where clause in a query. Can you please help how to format this

I need to use Today's date in a format like 2016-03-22T03:44:34.000-07:00 in a where clause in a query. Can you please help how to format this.
like 

SELECT id,name,SubscriptionId,createdDate FROM Amendment where createdDate = today

and today needs to be in this format, e.g.
2016-03-22T03:44:34.000-07:00

So, if I get system.today(); I need your help how to format that as I mentioned above.

Thank you