Ask again about comparing cast string to date

I am trying to select the records where the field activationtimestamp is within a certain range. Unfortunately the field activationtimestamp is defined as character(14) in the table. mysql> select * from SoutheastDB.SubscriptionVersion where date(activationtimestamp) > DATE_ADD('2004061807',

How to cast string to timestamp

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

How to export data with no headers?

Hi All, I am trying to export the records from the tables in the mysql database into a file. The problem I am having now is that I don't know how to export the records into a file without the header information, which is the name of columns. Can someone help? Thanks, Wenhong