Oops forgot to say the rest!
SELECT TO_CHAR(sale_date, 'Day DD Month YYYY HH24:MI:SS') as nice_sale_date
FROM sales
WHERE sales_id=3939
This would return
Nice_sale_date
------------------
Wednesday 25 October 2000 00:16:13
if you do the same query and add the NLS specifier
SELECT TO_CHAR(sale_date,'Day DD Month YYYY
HH24:MI:SS','NLS_DATE_LANGUAGE=FRENCH') as nice_sale_date
FROM sales
WHERE sales_id=3939
you get it in français
Nice_sale_date
------------------
Mercredi 25 Octobre 2000 00:16:13
Hth
s
-----Original Message-----
From: FARRAH NG [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2001 20:03
To: CF-Talk
Subject: defining french table in oracle
Hi everybody,
Does anyone has the experience of creating a oracle database to store
french characters ? Please give me advise of how to do this, if
anyone has this experience before.
thanks
--------------------------------------------------------------------------
Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
Sign-up today at http://www.hotvoice.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists