hi mailinglist,
i habe a simple question:
i created a table like:
create table "TABELLE" ("id" fixed(10) serial(1) primary key, "Zeit" date)
and insert some data in it:
insert into "TABELLE" ("Zeit") values ('2003-05-15')
insert into "TABELLE" ("Zeit") values ('2003-05-16')
insert into "TABELLE" ("Zeit") values ('2003-05-17')
Now i just want to get the daynumber of the date (15, 16, 17). Is there any
dateformatfunction to get this result?
I read under
http://www.sapdb.org/htmhelp/48/0d8018b4f211d2a97100a0c9449261/frameset.htm about the
two-digit day format, but how do i use this function??
If i write select format('DD', "Zeit") from "TABELLE" i get the result
DD 2003-05-15
DD 2003-05-16
DD 2003-05-17
also with select date_format... or select dateformat or select datetimeformat...
So, how must I use this format??
Thanks and greetings,
Andreas
______________________________________________________________________________
ComputerBild 15-03 bestaetigt: Den besten Spam-Schutz gibt es bei
WEB.DE FreeMail - Deutschlands beste E-Mail - http://web.de/?mc=021121
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
