Re: How to cast string to timestamp

[gerald_clark]

Cao, Wenhong wrote:
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
 

Why does the error report show (activationtimestamp) while your query 
does not?
Is this the actual query and error message?
It looks to me like you actually had (activationtimestamp), which is wrong.


 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]