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.

datetime format in ASA 10

3 posts in General Discussion Last posting was on 2007-08-23 18:07:47.0Z
Asanka Posted on 2007-08-23 05:54:41.0Z
Sender: 447d.46cd1eb5.1804289383@sybase.com
From: Asanka
Newsgroups: ianywhere.public.general
Subject: datetime format in ASA 10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46cd2121.44b8.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Aug 2007 22:54:41 -0700
X-Trace: forums-1-dub 1187848481 10.22.241.41 (22 Aug 2007 22:54:41 -0700)
X-Original-Trace: 22 Aug 2007 22:54:41 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6222
Article PK: 2634

I have MSSQL 2000 Server Database its works with distributed
transaction (com+) application is Microsoft.net platform

I want migrate this MSSQL 2000 databse in to ASA database
how can i do this

And what are the datetime format difference with ASA and
MSSQl2000

MSSQl datetime format is mm/dd/yyyy timestamp in binary data

cani have format datetime field like that in ASA and
timestamp save in binary data and timestamp has to update
Automatically


Breck Carter [Team iAnywhere] Posted on 2007-08-23 18:07:47.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: datetime format in ASA 10
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <ivirc35qpr8n3knikngcqusb1fcpu12i5h@4ax.com>
References: <46cd2121.44b8.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 23 Aug 2007 11:07:47 -0700
X-Trace: forums-1-dub 1187892467 64.7.134.118 (23 Aug 2007 11:07:47 -0700)
X-Original-Trace: 23 Aug 2007 11:07:47 -0700, bcarter.sentex.ca
Lines: 44
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6227
Article PK: 2636

I'm not sure I understand your question, but you may want to run this
in dbisql on the ASA database...

SET OPTION PUBLIC.DATE_FORMAT = 'mm/dd/yyyy';

SELECT CURRENT DATE; -- to test the result

There are also TIME_FORMAT and TIMESTAMP_FORMAT options; these all
control the format of the *string* value returned to a client
application by a SELECT statement, they *do not* affect the internal
representation of dates, times or timestamps which are not subject to
change as far as the internal storage is concerned. I think the same
is true of MSS.

Also note that the *input* format of dates (how input values are
interpreted) is controlled by the DATE_ORDER option. All of these are
described in the Help.

Breck

On 22 Aug 2007 22:54:41 -0700, Asanka wrote:

>I have MSSQL 2000 Server Database its works with distributed
>transaction (com+) application is Microsoft.net platform
>
>I want migrate this MSSQL 2000 databse in to ASA database
>how can i do this
>
>And what are the datetime format difference with ASA and
>MSSQl2000
>
>MSSQl datetime format is mm/dd/yyyy timestamp in binary data
>
>cani have format datetime field like that in ASA and
>timestamp save in binary data and timestamp has to update
>Automatically

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Chris Keating (Sybase iAnywhere) Posted on 2007-08-23 12:13:32.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: datetime format in ASA 10
References: <46cd2121.44b8.1681692777@sybase.com>
In-Reply-To: <46cd2121.44b8.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: keating-d620.sybase.com
X-Original-NNTP-Posting-Host: keating-d620.sybase.com
Message-ID: <46cd79ec$1@forums-1-dub>
Date: 23 Aug 2007 05:13:32 -0700
X-Trace: forums-1-dub 1187871212 10.25.99.252 (23 Aug 2007 05:13:32 -0700)
X-Original-Trace: 23 Aug 2007 05:13:32 -0700, keating-d620.sybase.com
Lines: 24
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6226
Article PK: 4664

See the following documentation reference for details:

SQL Anywhere® Server - SQL Usage >
Other SQL Dialects >
Configuring databases for Transact-SQL compatibility

The special Transact-SQL timestamp column and data type

Asanka wrote:
> I have MSSQL 2000 Server Database its works with distributed
> transaction (com+) application is Microsoft.net platform
>
> I want migrate this MSSQL 2000 databse in to ASA database
> how can i do this
>
> And what are the datetime format difference with ASA and
> MSSQl2000
>
> MSSQl datetime format is mm/dd/yyyy timestamp in binary data
>
> cani have format datetime field like that in ASA and
> timestamp save in binary data and timestamp has to update
> Automatically