0

I want to get the data from table last 5 days records I have seen examples they work fine for other data base but i am using amazon simple db so and sql razor I am using same query but it does not work and shows error 

SELECT *  
FROM UserContentUsage    
WHERE ViewDateTime BETWEEN DATE_SUB(CURDATE(), INTERVAL 5 DAY) AND CURDATE()
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user3110080
  • 57
  • 1
  • 8

1 Answers1

0

Amazon SimpleDB stores everything as UTF-8 strings. All comparisons are done lexicographically. The dates should be in ISO 8601 format so that they can be properly compared in lexicographical order.

See page for more detail.

Ashish Pancholi
  • 4,569
  • 13
  • 50
  • 88