Jump to content

MySQL

POWERED BY:

Sign In
Sign In

Remember me Not recommended on shared computers

Sign in anonymously

Forgot your password?
Sign Up

Archived

This topic is now archived and is closed to further replies.

QuinhOboOZ

pegando o dia da semana pelo mysql

By QuinhOboOZ, December 20, 2007 in MySQL

Recommended Posts

QuinhOboOZ 1

QuinhOboOZ

Report post

Posted December 20, 2007

Quero extrair o dia da semana(ex: sunday).

Me falaram que tem que fazer isso direto na query.

alguem sabe algo que possa me ajudar?

Share this post

Link to post

Share on other sites

giesta 29

Report post

Posted December 21, 2007

DATE_FORMAT(campo_da_data,'%W') as campo ---> Sunday ,Monday....

DATE_FORMAT(campo_da_data,'%w') as campo ---> 0 a 6, 0=Domingo, 6=Sabado

http://dev.mysql.com/doc/refman/5.0/en/dat...-functions.html

Share this post

Link to post

Share on other sites

Go To Topic Listing MySQL

- recuperando parametros simplexml_load_file
  
  By daemon, November 30 in PHP
- PHP+Codeigniter - Adicionar Registro Plano de Contas
  
  By violin101, November 20 in PHP
- Javascript - Passar Parâmetros para uma Função.
  
  By violin101, October 28 in Javascript

×

Forums
- Back
- Forums
- Calendar
- Our Picks
Activity
- Back
- Activity
- All Activity
- Search

Important Information

Ao usar o fórum, você concorda com nossos Terms of Use.