On Thu, 1999-09-30 12:46:34 -0600, Sasha Pachev wrote:
> "Jay A. Johnson" wrote:
> > This should be easy, but I can't seem to find it in the manual:
> > I have a TIMESTAMP column in one table (a.when) and a DATE column
> > (b.day) in another, and want to join the tables on these fields.
> > But "...where a.when=b.day" doesn't work, and I can't find a
> > DATEOF(timestamp) function that returns the date part. Right now
> > I'm using "... where DAYOFYEAR(a.when)=DAYOFYEAR(b.day)' as a
> > workaround, but that will break in about 360 days :-). TIA
> Try converting both to some common denominator such as Unix seconds.
I suggest using TO_DAYS which works with both DATE and DATETIME
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7