dbTalk Databases Forums  

Different Date format in two different databases in same ASE data server

comp.databases.sybase comp.databases.sybase


Discuss Different Date format in two different databases in same ASE data server in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chandan
 
Posts: n/a

Default Different Date format in two different databases in same ASE data server - 06-25-2004 , 03:20 PM






Any way can i setup two different data format in two different Sybase database,
These databases are in a same Sybase ASE data server.

What i like to do.
All transaction in database A using UK date format
And all transaction in database B using US date format.

Database A and B in same ASE server

Reply With Quote
  #2  
Old   
Michael Peppler
 
Posts: n/a

Default Re: Different Date format in two different databases in same ASE data server - 06-26-2004 , 02:00 AM






On Fri, 25 Jun 2004 13:20:31 -0700, Chandan wrote:

Quote:
Any way can i setup two different data format in two different Sybase
database, These databases are in a same Sybase ASE data server.

What i like to do.
All transaction in database A using UK date format And all transaction in
database B using US date format.

Database A and B in same ASE server
The date format is defined in the client application, not on the server.

So that's where you need to look to set your configuration.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.