What's the Current Week Number? |
Week number according to the ISO-8601 standard, weeks starting on Monday. The first week of the year is the week that contains that year's first Thursday.
The highest week number in a year is either 52 or 53.
my $weekNumber = POSIX::strftime("%V", gmtime time);
$weekNumber = date("W");
date("W", epoch) for other week numbers. Remember to use capital 'W' not 'w'.
SELECT WEEKOFYEAR(NOW())
SELECT WEEKOFYEAR('2008-02-20');
select week(now(),3))
SELECT DATEPART( wk, GETDATE() )