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
