Hello Jose,
Regarding: "...but I need to get the week of that month based on the date."
One interpretation of your question might me:
Given a date "d", which, say, falls on a Wednesday, then return
1, 2, 3, 4, or 5 denoting whether d is on the 1st, 2nd, 3rd, 4th, or
5th Wednesday of that month.
If that's the question, then the sqlite (or C) expression:
1 + (d - 1) / 7
should do it (where the slash represent truncating integer division)
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
