Is there an easy way to format a date (German format) within an expression?
I want this result:

Patient: Gail Mazen, geb. 6.2.1976

from name, given Name and birthday

... or have I to use something like this (which actually works):

select
'Patient: ' + Vorname + ' ' + Name + ', geb. ' +
Cast(extract(Day from Gebdat) as VarChar(2))
+ '.'
+  Cast(extract(Month from Gebdat) as VarChar(2))
+'.'
+  Cast(extract(Year from Gebdat) as VarChar(4))
from Patienten;

Regards Uli

Uli


You'll have to use your current approach or write a UDF.

Roy Lambert

Uli,

<< Is there an easy way to format a date (German format) within an
expression? >>

We have this on our list of minor enhancements for 2.0, but for now you'll
have to just write a function to do so.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,
<<
We have this on our list of minor enhancements for 2.0, but for now you'll
have to just write a function to do so.
>>

Thanks. Still learning the basics of EDB: can you give me a small example how to use a
function within an SQL-expression. I didn't find it in the manuals.

Uli

Uli

Once you've got your function working and linked in you just call it like

MyDateFormat(Gebdat)

as a column in the sql.

Writing it, for what you want could be either sql or Delphi, but since you already have the sql code you could just move that into a function


Roy Lambert

Roy,

<<
Once you've got your function working and linked in you just call it like
MyDateFormat(Gebdat)
>>

Didn't know that it's that easy Thanks.

Uli

Uli,

<< Thanks. Still learning the basics of EDB: can you give me a small example
how to use a function within an SQL-expression. I didn't find it in the
manuals. >>

Sure, just define the function like this:

CREATE FUNCTION "FormatDate" (IN "InDate" DATE)
RETURNS VARCHAR(10) COLLATE ANSI
BEGIN
  RETURN CAST(EXTRACT(DAY FROM InDate) as VARCHAR(2)) + '.' +
         CAST(EXTRACT(MONTH FROM InDate) as VARCHAR(2)) + '.' +
         CAST(EXTRACT(YEAR FROM InDate) as VARCHAR(4));
END

And then just use it in an SQL statement like a normal function:

SELECT FormatDate(MyDateColumn) AS GermanDate FROM MyTable

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> CREATE FUNCTION "FormatDate" (IN "InDate" DATE)
> RETURNS VARCHAR(10) COLLATE ANSI
> BEGIN
>   RETURN CAST(EXTRACT(DAY FROM InDate) as VARCHAR(2)) + '.' +
>          CAST(EXTRACT(MONTH FROM InDate) as VARCHAR(2)) + '.' +
>          CAST(EXTRACT(YEAR FROM InDate) as VARCHAR(4));
> END

Great. Thank you!

Uli