Hi, I am trying to get the records for the activationstamp within a certain range. The activationstamp is defined as character(14) in the ddl.
I don't know how to cast the activationstamp field to timestamp before doing the comparison. I tried to use date(), but it didn't work. My server version is 3.23.57. How to get around this? Any help is welcome. select * from SoutheastDB.SubscriptionVersion where activationtimestamp > DATE_ADD('20040618070000', INTERVAL 5 HOUR) and activationtimestamp <= '20040619065959' limit 1; [lsms] ERROR 1064: You have an error in your SQL syntax near '(activationtimestamp) > DATE_ADD('20040618070000', INTERVAL 5 HOUR) and activati' at line 1 Thanks, Wen