SQL Work Week in format yyyyww
Does anyone know how i can filter a table by next weeks work week in the
format 201337 which is yyyyww format.
The table would look like this
ww col1
201336 xx
201337 yy
201338 zz
i want to select 201336 xx. I normally use CURRENT_TIMESTAMP for
timeDate:now but not sure how to get that to yyyyww
No comments:
Post a Comment