Cao, Wenhong wrote:
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.
Perhaps you should change the type of activationtimestamp:
ALTER TABLE SubscriptionVersion
'20040619065959' limit 1;
-Original Message-
From: Cao, Wenhong
To: [EMAIL PROTECTED]
Sent: 6/17/04 1:52 PM
Subject: 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 fi
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',