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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
include either OR or AND in SQL statement 2
Insert into ..... Select statements. 4
2007 to 2003 function problem 1
recordset query 2
mySQL datetime field reports as Long Integer with ODBC 2
SQl query in VBA - SELECT inside an INSERT INTO 10
IN in query 8

Back
Top