Jump to content


Photo

MySql Date search


  • Please log in to reply
1 reply to this topic

#1 d_barszczak

d_barszczak
  • Members
  • PipPipPip
  • Advanced Member
  • 188 posts
  • LocationBradford - UK

Posted 23 August 2006 - 11:02 AM

Hi,

I have designed a call managment system and im currently working on a report.

I have stored all dates as unix timestamps and i need to searc all jobs completed on
a certain date ie all jobs complete on 22 August but abviouslt the timestamp goes right
down to each second.

Any help would be great.

When all else fails - Try reading the manual.

Integrated IT Systems Ltd


#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 23 August 2006 - 01:16 PM

You'll need to use a date range, or use the DATE() function.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users