I am in need of a query in Mysql

  • Thread starter Thread starter rajsmashr
  • Start date Start date
R

rajsmashr

i need a query in mysql .... To find particular date belong to which
week of the year....

here my input is Date ...

output should be which week of the year...
 
May be MySQL has some dedicated newsgroup(s) where more users would be able
to give you a faster answer than here, if the query has to be written
directly in MySQL. On the other hand, if you are linked to MySQL through
Access, then ODBC (and Jet) could 'probably' do it for you: do the query in
Jet, and it should be translated back, if required, to MySQL. In Access
(Jet), you will ask for DatePart("ww", yourDateTimeFieldHere)


DatePart has more optional arguments which allow you to define which week is
week one, if the default does not match your preference.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top