Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #13870

Re: How to loop through the dates?

Show all headers | View raw

richard <noreply@example.com> wrote in news:cyaf96m0jpev$.1a2m47bjjrqjk$.dlg@
40tude.net:

> In this instance "date" in the line you left quoted, refers to a column
> name.

Yes, we understand this. You don't appear to understand that *calling* a string column 
"date" doesn't actually *make* it a date. A string column named "date", and a DATE 
column are distinctly different data types.

> What if it had been "hits" instead or "title"?

Then you wouldn't have a problem -- because SQL sorts both numeric data and string data 
in the order you expect it to be sorted, but when you store a date as a MMDDYYYY string, 
the sorted order is *not* what you expect.

> You guys are hell bent on this date issue you forget that columns can hold
> any data in any manner.Regardless of their name.

We're not forgetting anything. You are failing to realize that strings are not appropriate 
storage types for date data.

> The only two things the table cares about is, the data is either a string
> or a numeric.

Patently false. Those are not the only types of data that can be stored in a SQL database. 
You, in particular, have no excuse for being unaware of that fact, since you have been told 
many times that you should store dates using the DATE data type. This you have 
truculently and ignorantly refused to do.

And now you have a perfect example of *why* you were advised to use the DATE date 
type to store date information.

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

How to loop through the dates? richard <noreply@example.com> - 2014-06-15 12:11 -0400
  Re: How to loop through the dates? Luuk <luuk@invalid.lan> - 2014-06-15 18:38 +0200
    Re: How to loop through the dates? Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-15 17:43 +0000
      Re: How to loop through the dates? Luuk <luuk@invalid.lan> - 2014-06-15 20:03 +0200
  Re: How to loop through the dates? Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-15 17:40 +0000
    Re: How to loop through the dates? richard <noreply@example.com> - 2014-06-15 13:59 -0400
      Re: How to loop through the dates? Luuk <luuk@invalid.lan> - 2014-06-15 20:27 +0200
      Re: How to loop through the dates? Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-15 19:14 +0000
      Re: How to loop through the dates? Doug Miller <doug_at_milmac_dot_com@example.com> - 2014-06-15 21:39 +0000
      Re: How to loop through the dates? Arno Welzel <usenet@arnowelzel.de> - 2014-06-17 08:12 +0200
    Re: How to loop through the dates? Luuk <luuk@invalid.lan> - 2014-06-15 20:01 +0200
      Re: How to loop through the dates? Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-15 19:07 +0000
        Re: How to loop through the dates? Luuk <luuk@invalid.lan> - 2014-06-15 21:58 +0200
          Re: How to loop through the dates? Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-16 00:55 +0000
        Re: How to loop through the dates? richard <noreply@example.com> - 2014-06-16 13:02 -0400
          Re: How to loop through the dates? Doug Miller <doug_at_milmac_dot_com@example.com> - 2014-06-16 17:57 +0000
    Re: How to loop through the dates? Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2014-06-15 19:14 -0400
      Re: How to loop through the dates? richard <noreply@example.com> - 2014-06-16 12:26 -0400
        Re: How to loop through the dates? Doug Miller <doug_at_milmac_dot_com@example.com> - 2014-06-16 16:39 +0000
        Re: How to loop through the dates? Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2014-06-16 14:14 -0400
        Re: How to loop through the dates? Arno Welzel <usenet@arnowelzel.de> - 2014-06-17 08:18 +0200
  Re: How to loop through the dates? Tim Streater <timstreater@greenbee.net> - 2014-06-15 20:30 +0100
    Re: How to loop through the dates? Luuk <luuk@invalid.lan> - 2014-06-15 22:01 +0200
      Re: How to loop through the dates? Tim Streater <timstreater@greenbee.net> - 2014-06-15 21:34 +0100
        Re: How to loop through the dates? Luuk <luuk@invalid.lan> - 2014-06-15 23:32 +0200
        Re: How to loop through the dates? richard <noreply@example.com> - 2014-06-16 12:19 -0400
          Re: How to loop through the dates? Norman Peelman <npeelman@cfl.rr.com> - 2014-06-16 20:44 -0400
  Re: How to loop through the dates? Norman Peelman <npeelman@cfl.rr.com> - 2014-06-15 20:59 -0400

csiph-web