> i created a table like:
> create table "TABELLE" ("id" fixed(10) serial(1) primary key,
> "Zeit" date)
[...]
> Now i just want to get the daynumber of the date (15, 16,
> 17). Is there any dateformatfunction to get this result?
You can use the function DAY()
<http://www.sapdb.org/7.4/htmhelp/5b/330170bc0d11d2a97100a0c9449261/frameset.htm>
This returns a number, not a string.
Daniel Dittmar
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
