Jump to content


Photo

Obter Rows De No Minimo 3 Dias Atrás


  • Faça o login para participar
5 replies to this topic

#1 Emerine

Emerine

    Normal

  • Usuários
  • 79 posts
  • Sexo:Não informado

Posted 14/01/2015, 23:00

Tenho uma tabela com coluna datetime e preciso obter os resultados que ja tenham 3 dias de existencia, todos com mais de 3 dias, tentei usar

SELECT *, DATE_FORMAT(date, '%m/%d/%Y') FROM tb WHERE DATE(date) = CURDATE() - INTERVAL 3 DAY ORDER BY ID DESC

porém nao deu.



#2 Danilomaru

Danilomaru

    Ativo

  • Moderadores
  • 300 posts
  • Sexo:Masculino
  • Localidade:brasil

Posted 16/01/2015, 11:39

Seu where deve ser:

WHERE DATE(date) < DATE_SUB(CURDATE(), INTERVAL 3 DAY)


#3 RonsisM

RonsisM

    Super Veterano

  • Usuários
  • 15724 posts
  • Sexo:Masculino
  • Localidade:Plovdiv

Posted 13/09/2017, 21:37

Tretinoin 20 20 Gm From India cialis Buy Clomid Safely Online Uk Paypal
Precios Cialis Online Avamigran
Propecia Resultados <a href=http://cialtobuy.com>cialis</a> Preisvergleich Cialis 20mg Filmtabletten
Propecia Plm cheap cialis Cialis Contraindicaciones Alcohol 2053 Med Direct Cialis Efectos Secundarios A Largo Plazo cialis buy online Online Pharmacy Uk Viagra
Worldwide Generic Dutasteride 0.5mg Canada Amex No Prescription Needed generic cialis Cialis Generico A Prezzi Bassi
where to order direct isotretinoin 10mg tablets Buy Generic Levitra Online Buy Viagra Next Day Shipping
Cialis Genericos <a href=http://cialtobuy.com>cialis</a> Where To Buy Silagra
Cialis Diario 5 Mg cialis Viagra Pfizer 100mg Price Je Peux Acheter Kamagra Propecia Geheimratsecken Amoxicillin Macaw Bacterial Infection Viagra 70 cialis price Cialis With Prescription

#4 RonsisM

RonsisM

    Super Veterano

  • Usuários
  • 15724 posts
  • Sexo:Masculino
  • Localidade:Plovdiv

Posted 02/10/2017, 04:18

Prescription Drugs No viagra Online No Prescrption Pharmacy
Amoxil By Vbulletin Intitle View Profile New Canadian Meds viagra Can You Puchase Prochlorperazine Online Inhousepharmacy Cialis Viagra Generico Online

#5 RonsisM

RonsisM

    Super Veterano

  • Usuários
  • 15724 posts
  • Sexo:Masculino
  • Localidade:Plovdiv

Posted 28/10/2017, 15:55

Can You Buy Flagyl Over The Counter Forte Propecia Generico Canadian Pharmacies Viagra viagra Average Dose Of Amoxicillin
Emsam Viagra Urgente Cheap Doryx No Prescription Needed viagra cialis Cialis 5mg Schweiz Cialis Effetti Durata Priligy Approved By Fda

#6 RonsisM

RonsisM

    Super Veterano

  • Usuários
  • 15724 posts
  • Sexo:Masculino
  • Localidade:Plovdiv

Posted 12/11/2017, 21:10

Commander Baclofene En Ligne Finpecia From India Online levitra canada free shipping Cialis Mg Strength
Cialis Ketoconazol Pharm Support Group In Canada Pharmacy Rx One Viagra india 4 pharmacy levitra cheap Levitra Order Amoxicillin For Pets Without Prescription




2 user(s) are reading this topic

0 membro(s), 2 visitante(s) e 0 membros anônimo(s)

IPB Skin By Virteq