why do people use 23:59:59 with dates?

[iostream71]

i see examples of people using that, like:
"1999-07-02 23:59:59" when querying for a date

 

[KarveR]

Well I guess it depends on whether you store your dates using a timestamp and how you return them using date_format(date_field, bunch of stuff here to get the date time etc etc) ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[iostream71]

ok, say i want to select all the people in a date range, like:

select * from myTable where TO_DAY(NOW()) - TO_DAY(theirDate) > 0

i have their date field as a "date"...will that work ok, or should i use timestamp instead??

 

[KarveR]

It really depends quite how the date field was set up, e.g. DATETIME, DATE, TIMESTAMP, TIME, and YEAR.

Any of these will return a valid value except TIMESTAMP if the timestamp field is limited to just year and month or just year.

With me so far? ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[iostream71]

think so. i just wanted to be guaranteed i was selected all the people i needed. if i'm using date, i don't need to worry about the timestamping part then?

 

[KarveR]

no, time is optional when pulling by date from any of the above so long as they have enough content to cover what you request.

If you tried to pul from a YY-MM timestamp it would go a little wobbly. Other than that you should be OK. ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.