Alexander Foken schrieb:
On 18.05.2009 15:42, Tod A. Sandman wrote:
On Sat, May 16, 2009 at 06:07:05PM +0200, Alexander Foken wrote:
[snip]
I tried using "TOCHAR" verbatim (I'm ultra weak in sql), but I got a
mysql syntax error (I'm using mysql-4.1.22).
Yes, TOCHAR is what I've remembered from Oracle. But it wouldn't work
there, because its spelled TO_CHAR. It seems there is no standard in SQL
for converting data types, each RBDMS has its own way.
That is nearly right. CONVERT is the SQL-standard function to do this, but it is
not implemented by every RDBMS. And if it is there, the syntax differs...
But may be there is a converging process to more and more standard support.
Greetings
Robert
--
======================================================
Robert Roggenbuck
Institut fuer wissenschaftliche Information e.V. (IWI)
Fachbereich Mathematik / Informatik
Universitaet Osnabrueck
http://www.iwi-iuk.org
======================================================
