Re: Date String Conversion error
Ernest Chen wrote:
>
> The document for Online Server v7.1 says I can do this:
>
> insert into mytable (subscription_date, email)
> values('1997-01-11 08:45', "hello");>
> subscription_date has a data type of 'date'
>
> I received date string conversion error, can anybody help??
'1997-01-11 08:45' is a datetime
subscription_date is a date
Dates need to match your DBDATE environment variable, and can't have
a time component
HTH
Vic
--
Victor Goldberg
vic@tc.cornell.edu