Re: Quantity of time from difference of two Datetime values?

2011-10-01 Thread Jan Steinman
Thanks, Hank! I figured it was something like that, but couldn't see any clear documentation on the Oracle reference page on date/time functions. On Sep 30, 2011, at 8:22 PM, Hank wrote: > n Fri, Sep 30, 2011 at 11:08 PM, Jan Steinman wrote: >> Okay, I've reviewed the online man page for date

The rarest

2011-10-01 Thread Hal�sz S�ndor
Which of these statements for picking one of the rarest "Boardster"s do best like? SELECT Boardster FROM (SELECT count(*) as N FROM memberaddress GROUP BY Boardster order by N limit 1) aS P join (SELECT count(*) AS N, boardster FROM memberaddress GROUP BY Boardster) as Q USING (N

NULL-safe (in)equality <=>

2011-10-01 Thread Hal�sz S�ndor
It is, of course, generally considered more natural to make equality primary, not inequality, but that symbol that MySQL uses for NULL-safe equality, <=>, looks much more like inequality than equality. Furthermore, I find that in my code I am far oftener interested in NULL-safe _in_equality than

Налоговое законодательство в 2011г. практика оптимальных решений

2011-10-01 Thread Страховые взносы 2011
13-14 октября 2011 г. ТЕМА: Практика в налоговых схемах с учетом изменений налогового законодательства. Поиск и принятие оптимальных решений Оптимизируем налоги (НДФЛ, страховые взносы, НДС, налог на прибыль). Московский код; 22I8Ч-30 или 22I_8ЧЗI День1: Методы оптимизации расходов на выплату

Re: Quantity of time from difference of two Datetime values?

2011-10-01 Thread Hal�sz S�ndor
2011/09/30 20:08 -0700, Jan Steinman Okay, I've reviewed the online man page for date and time functions, and I've played with several likely candidates, and I am still having trouble subtracting two arbitrary Datetimes to get something that is useful. A simple subtraction yields the l