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


Reply via email to