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',
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
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