Member Avatar for ramsiva

I am not getting records
In my DB modify_date structure is timestamp

my query is

SELECT * FROM table WHERE 
modify_date> 2015-09-29 13:50:13

any body help me

  • 2 Contributors
  • 1 Reply
  • 136 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

You're missing quotes:

SELECT * FROM table WHERE modify_date > '2015-09-29 13:50:13'
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.