Re: get week from date/datetime field

Pohoda schrieb: > Hi, > > I have a very basic quesetion but I can't find > any answer by myself. Is it possible to extract > number of week from date/datetime column? > Thanks for any advice! > > Ondrej Volrab > Try searching groups.google.com for a thread called "ISO 8601 Week Number Stored Procedures" posted by Jonathan Leffler. He wrote a stored procedure to convert date and datetime fields to week numbers. -- Roland Wintgen (Systemadministrator) EVG Elektro-Vertriebs-Gesellschaft Martens GmbH & Co KG Trompeterallee 244-246, D-41189 Moenchengladbach Tel. +49 21 66 / 55 08 23, Fax +49 21 66 / 55 08 90 www.evg.de rw@evg.de