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.

Improve internationalization

4 posts in Product Futures Discussion Last posting was on 2003-04-29 13:52:58.0Z
Olivier Posted on 2003-04-25 08:45:17.0Z
From: "Olivier" <ociteau-NOCANSPAM@yahoo.fr>
Organization: 212.234.59.105
X-Newsreader: AspNNTP 1.50 (C I Host)
Subject: Improve internationalization
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <#HXcAcwCDHA.280@forums-2-dub>
Newsgroups: sybase.public.ase.product_futures_discussion
Date: Fri, 25 Apr 2003 01:45:17 -0700
NNTP-Posting-Host: 66.221.40.1
Lines: 19
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1178
Article PK: 95417

Hi, as an application developper, i was luckily enough to work with Oracle, ASE,
ASA.
I found Oracle very flexible for converting date or number to/from string.

With ASE to diplay a date in french format, i can use format '103' but then i
lose the time. When i want to display date+time i need to keep american format.
With Oracle i could specify a format like this : 'dd/mm/yyyy hh:mi:ss'

In france we use ',' as decimal separator.
So, i write : stuff (str (amount,10,2), 8, 1, ',')
I wish i could write : convert ( varchar(10), amount, 'fr')

It makes me think of a great feature :
Allow us to create stored functions (like Oracle does).
--
Olivier Citeau from Paris, France
posted via pfcguide.com


Bret Halford Posted on 2003-04-26 15:41:52.0Z
Message-ID: <3EAAA8C0.8426DE82@sybase.com>
Date: Sat, 26 Apr 2003 09:41:52 -0600
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Improve internationalization
References: <#HXcAcwCDHA.280@forums-2-dub>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: vpn-dub-023.sybase.com 10.22.120.23
Lines: 31
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1179
Article PK: 95419


Olivier wrote:
>
> Hi, as an application developper, i was luckily enough to work with Oracle, ASE,
> ASA.
> I found Oracle very flexible for converting date or number to/from string.
>
> With ASE to diplay a date in french format, i can use format '103' but then i
> lose the time. When i want to display date+time i need to keep american format.
> With Oracle i could specify a format like this : 'dd/mm/yyyy hh:mi:ss'
>
> In france we use ',' as decimal separator.
> So, i write : stuff (str (amount,10,2), 8, 1, ',')
> I wish i could write : convert ( varchar(10), amount, 'fr')
>
> It makes me think of a great feature :
> Allow us to create stored functions (like Oracle does).
> --
> Olivier Citeau from Paris, France
> posted via pfcguide.com

While I agree that a more flexible means for specifying formats when
converting
to a string is desirable, you can certainly have the french format with
time
without much difficulty:

select convert(varchar,DATE,103) + " " + convert(varchar(DATE,108)

ASE has supported user-defined functions since ASE 12.0, see the CREATE
FUNCTION
command in the Reference Manual. (I don't know how Oracle has
implemented the
feature).

-bret


Olivier Citeau Posted on 2003-04-27 20:09:44.0Z
From: "Olivier Citeau" <ociteau.nospam@free.fr>
References: <#HXcAcwCDHA.280@forums-2-dub> <3EAAA8C0.8426DE82@sybase.com>
Subject: Re: Improve internationalization
Date: Sun, 27 Apr 2003 22:09:44 +0200
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <euthGkPDDHA.331@forums-1-dub>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: nas-cbv-5-62-147-145-108.dial.proxad.net 62.147.145.108
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1182
Article PK: 95423

"Bret Halford" <bret@sybase.com> a écrit dans le message news:
3EAAA8C0.8426DE82@sybase.com...

>
>
> Olivier wrote:
> >
> > Hi, as an application developper, i was luckily enough to work with
Oracle, ASE,
> > ASA.
> > I found Oracle very flexible for converting date or number to/from
string.
> >
> > With ASE to diplay a date in french format, i can use format '103' but
then i
> > lose the time. When i want to display date+time i need to keep american
format.
> > With Oracle i could specify a format like this : 'dd/mm/yyyy hh:mi:ss'
> >
> > In france we use ',' as decimal separator.
> > So, i write : stuff (str (amount,10,2), 8, 1, ',')
> > I wish i could write : convert ( varchar(10), amount, 'fr')
> >
> > It makes me think of a great feature :
> > Allow us to create stored functions (like Oracle does).
> > --
>
> While I agree that a more flexible means for specifying formats when
> converting
> to a string is desirable, you can certainly have the french format with
> time
> without much difficulty:
>
> select convert(varchar,DATE,103) + " " + convert(varchar(DATE,108)
>
> ASE has supported user-defined functions since ASE 12.0, see the CREATE
> FUNCTION
> command in the Reference Manual. (I don't know how Oracle has
> implemented the
> feature).
>
> -bret

Great ! I am glad to hear that. It's only one month since i work with
ASE12.0, and i had not noticed that.
Despite i red the "what's new" in french.

From the 3 things i asked, i'll keep only one : possible use of a format in
order to convert a number to String (and not only date).

Many thanks for your answer Bret.
Sorry that i answered directly to you, i had clicked on bad buton in
outlook.


Olivier Posted on 2003-04-29 13:52:58.0Z
From: "Olivier" <ociteau-NOCANSPAM@yahoo.fr>
Organization: 212.234.59.105
References: <#HXcAcwCDHA.280@forums-2-dub> <3EAAA8C0.8426DE82@sybase.com> <euthGkPDDHA.331@forums-1-dub>
X-Newsreader: AspNNTP 1.50 (Tri Hoang)
Subject: Re: Improve internationalization
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <eayplalDDHA.81@forums-2-dub>
Newsgroups: sybase.public.ase.product_futures_discussion
Date: Tue, 29 Apr 2003 06:52:58 -0700
NNTP-Posting-Host: dsl-206.169.167.22.wenet.com 206.169.167.22
Lines: 17
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1185
Article PK: 95424

On Sun, 27 Apr 2003 22:09:44 +0200,
in sybase.public.ase.product_futures_discussion

>> ASE has supported user-defined functions since ASE 12.0, see the CREATE
>> FUNCTION
>> command in the Reference Manual. (I don't know how Oracle has
>> implemented the
>> feature).
>>
>> -bret

NO ! there is no user defined function in ASE 12.0.
"CREATE FUNCTION" exists since ASE 12.5, but it is a wrapper around a static
java function.
You cannot create a function in pure T-SQL.

Syntax would be easy :
Create function foo (@i int) return int AS
-- blah
return 2*@i
go


--
Olivier Citeau from Paris, France
posted via pfcguide.com