Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

change a char to a date problem!!

2 posts in General Discussion Last posting was on 2004-06-03 12:51:06.0Z
jabuit Posted on 2004-06-03 11:32:29.0Z
Sender: 1379.40bf0b8b.1804289383@sybase.com
From: jabuit
Newsgroups: ianywhere.public.general
Subject: change a char to a date problem!!
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40bf0c8f.138b.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 3 Jun 2004 04:33:35 -0700, 10.22.241.42
Lines: 6
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Jun 2004 04:30:31 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Jun 2004 04:32:29 -0700
X-Trace: forums-1-dub 1086262349 10.22.108.75 (3 Jun 2004 04:32:29 -0700)
X-Original-Trace: 3 Jun 2004 04:32:29 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3092
Article PK: 6555

"Restricted data type attribute violation: cannot convert
2-10-2003 to a timestamp." this the message.

the new date filed has the same properties with the old one
that works.
please any help !!


Jason Hinsperger Posted on 2004-06-03 12:51:06.0Z
From: "Jason Hinsperger" <NOJason_HinspergerSPAM@hotmail.com>
Newsgroups: ianywhere.public.general
References: <40bf0c8f.138b.1681692777@sybase.com>
Subject: Re: change a char to a date problem!!
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-Original-NNTP-Posting-Host: hinsperg-pc1.sybase.com
Message-ID: <40bf1efe$1@forums-2-dub>
X-Original-Trace: 3 Jun 2004 05:52:14 -0700, hinsperg-pc1.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Jun 2004 05:49:09 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Jun 2004 05:51:06 -0700
X-Trace: forums-1-dub 1086267066 10.22.108.75 (3 Jun 2004 05:51:06 -0700)
X-Original-Trace: 3 Jun 2004 05:51:06 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3095
Article PK: 6553

Check your database DATE_ORDER option. It defines how string date values
are interpreted.
Also, if you are using ODBC, be aware that by default, ODBC sets the
date_order to YMD (year, month, day)

--
Jason Hinsperger
Product Management
iAnywhere Solutions

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
--

<jabuit> wrote in message news:40bf0c8f.138b.1681692777@sybase.com...
> "Restricted data type attribute violation: cannot convert
> 2-10-2003 to a timestamp." this the message.
>
> the new date filed has the same properties with the old one
> that works.
> please any help !!