Re: Date question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



For example, you have table `logs` with `datelog` field and you want to
select dates
that match 2006-02. You can try this select statement:

SELECT * FROM `logs` WHERE MONTH(datelog)='02' and YEAR(datelog)='2006'

Hope that helps.

LJ Regalado

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux