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.

Date Data Types

3 posts in PB Infomaker Report Writer Last posting was on 1998-11-18 15:34:16.0Z
Bill Chadbourne Posted on 1998-11-18 10:29:02.0Z
Newsgroups: sybase.public.infomaker.general
From: "Bill Chadbourne" <wchad@ime.net>
Subject: Date Data Types
Date: Wed, 18 Nov 1998 05:29:02 -0500
Lines: 15
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_mLA80UtE#GA.302@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6718
Article PK: 241704

I have created a table in SAS 6 and defined the date format to be Date
(mm/dd/yyyyy) so any date that is entered looks like '08/31/1998'. When I
want to report on this table and put "start_date = '08/31/1998' in the
WHERE clauseI get an ODBC error that says "cannot convert '08/31/1998' to
datetime". Doesn't infomaker recognize data formats defined in SQL Anywhere
6.0?

TIA,

Bill Chadbourne
wchad@gwi.net
wchad@ime.net


Terry Dykstra Posted on 1998-11-18 15:34:16.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Date Data Types
Date: Wed, 18 Nov 1998 08:34:16 -0700
Lines: 25
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_YRE417vE#GA.302@forums.powersoft.com>
References: <348_mLA80UtE#GA.302@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6716
Article PK: 241701

You can try using '08/31/98'. It depends on the short-date setting in your
control panel. But as Rick pointed out, using the international format of
yyyy/mm/dd is the better way.

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Bill Chadbourne wrote in message ...
>I have created a table in SAS 6 and defined the date format to be Date
>(mm/dd/yyyyy) so any date that is entered looks like '08/31/1998'. When I
>want to report on this table and put "start_date = '08/31/1998' in the
>WHERE clauseI get an ODBC error that says "cannot convert '08/31/1998' to
>datetime". Doesn't infomaker recognize data formats defined in SQL Anywhere
>6.0?
>
>TIA,
>
>Bill Chadbourne
>wchad@gwi.net
>wchad@ime.net
>
>
>


Rick Marden Posted on 1998-11-18 13:28:16.0Z
Newsgroups: sybase.public.infomaker.general
From: "Rick Marden" <mardens@cybertours.com>
Subject: Re: Date Data Types
Date: Wed, 18 Nov 1998 08:28:16 -0500
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.0810.800
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800
Message-ID: <348_HbOCU1uE#GA.302@forums.powersoft.com>
References: <348_mLA80UtE#GA.302@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6717
Article PK: 241703

This will work:
start_date = '1998-08-11'

Rick Marden
Primavera Systems

Bill Chadbourne <wchad@ime.net> wrote in message
news:mLA80UtE#GA.302@forums.powersoft.com...
>I have created a table in SAS 6 and defined the date format to be Date
>(mm/dd/yyyyy) so any date that is entered looks like '08/31/1998'. When I
>want to report on this table and put "start_date = '08/31/1998' in the
>WHERE clauseI get an ODBC error that says "cannot convert '08/31/1998' to
>datetime". Doesn't infomaker recognize data formats defined in SQL Anywhere
>6.0?
>
>TIA,
>
>Bill Chadbourne
>wchad@gwi.net
>wchad@ime.net
>
>
>