On 1 May, 12:10, skinhat <skin...@gmail.com> wrote:
> On May 1, 9:06 pm, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
>
>
>
>
> > On 1 May, 12:03, skinhat <skin...@gmail.com> wrote:
>
> > > On May 1, 8:49 pm, "J.O. Aho" <u...@example.net> wrote:
>
> > > > skinhat wrote:
> > > > >> SELECT
> > > > >> DISTINCT `sid`
> > > > >> WHERE LEFT(FROM_UNIXTIME(`cid`),10) = '2007-12-08';
>
> > > > > This wouldnt work because the 'cid' field doesnt hold the date. Its
> > > > > just a unique identifier.
>
> > > > Yes, the cid column does hold the date, it's just in a unixtime format and the
> > > > FROM_UNIXTIME() function would then convert it to a human readable format
>
> > > Notice in the table these records:
>
> > > 2 1176718828 0 12
> > > 2 1176718828 1 18
> > > 2 1176718828 2 2007
>
> > > 3 1176718828 0 4
> > > 3 1176718828 1 5
> > > 3 1176718828 2 2008
>
> > > Both have the same CID yet represent different dates. The first is
> > > 12/18/2007 and the second is 4/5/2008.
>
> > If they both have the same cid value than it is hardly a "unique"
> > identifier!
>
> The CID is unique to a certain date field. 1176718828 represents a
> date where no=0 is the day, no=1 month and no=2 is the year. A SID is
> equivalent to a record. This is the way drupal do it (www.drupal.org)
> for its webform module for dates.- Hide quoted text -
>
> - Show quoted text -
No you are wrong. Unique means it is the only one of it's kind. This
is not at all unique. It seems to be some sort of field identifier
(that just happens to look like a unix timestamp. Date fields seem to
be identified by a cid of either 1176718828 or 1176851105, whilst
email addresses are identified by a cid of 1176015743, first names by
1176015500, last names by 1176015691, request info by 1177590862 and
so on. It is my guess that the cid of 1176718828 represents one type
of date (e.g. creation date) whilst 1176851105 may represent last
update date (note that these cannot be the correct descriptions as all
the dates are in the future.
I will craft you a self join query that looks at the 1176718828 type
dates, but you need to identify which of the dates it is that are
relevant to you.