Piggybank used to contain toWeek? Russell Jurney http://datasyndrome.com
On Apr 20, 2012, at 5:23 AM, "Shin Chan" <[email protected]> wrote: > Hello Dan > > thank you , i wrote my own UDF > > Just wondering how i could share it someway with others. > > > > > > ----- Original Message ----- > From: Dan Feldman > Sent: 04/20/12 02:36 AM > To: [email protected] > Subject: Re: UDF to find Week > > I highly doubt there are UDFs written for this sort of thing, but you could > figure out a week of the year with unix command (for example): date -d > '2012-04-13 11:43:03' '+%U' if that helps. '+%U' gives you the week number > (see http://manpages.ubuntu.com/manpages/intrepid/man1/date.1.html) Dan F. On > Thu, Apr 19, 2012 at 11:09 PM, Shin Chan <[email protected]> wrote: > Hi all my > date is of the form > > YYYY-MM-DD HH:MM:SS.XXX > > How to find week for this > ( 1-52 year week for given date) , any UDF for > this ? > > Thanks and > Regards , > > > > > Thanks and Regards ,
