OpenForum RSS: �� $date � bash ��

�� $date � bash �� (madmax11)

Thu, 10 Feb 2011 12:03:01 GMT

>[�� ]
>> �� and time>='2010-12-20 ��
>> �� CURDATE(), �� , ��
>> �� =(
> �� SQL :( �� -�� , ��, ��
> �� , �� .
> � �� , ��
> � �� , �� . �� ,
> �� /��. (�� ݣ ��
> �� , �� "��
> �� ".)

��, �� , � �� , �� , �� , � �� , � �� mysql, � � �� =) �� DATE_SUB(CURDATE(), INTERVAL 7 DAY) � �� , � DATE_SUB(NOW(), interval 1 day) ��

�� $date � bash �� (phpcoder)

Thu, 10 Feb 2011 11:24:03 GMT

> select day(time),hour(time), sum(msg_len) from info where (locate('***',***)=1 or locate('***',***)=1)
> and time>='2010-12-20 00:00:00' and time<'�URDATE() 00:00:00' group by *,* order by
> time; �� , ��
> �� and time>='2010-12-20 ��
> �� CURDATE(), �� , ��
> �� =(

�� SQL :( �� -�� , ��, �� , �� .

� �� , �� , �� . �� , �� /��. (�� ݣ �� , �� "�� ".)

�� $date � bash �� (madmax11)

Thu, 10 Feb 2011 11:12:40 GMT

>>> �� , �� 7 ��.
>> �� (NOW(), CURDATE()) �� .

� �� , �� , � �� , �� :

select day(time),hour(time), sum(msg_len) from info where (locate('***',***)=1 or locate('***',***)=1) and time>='2010-12-20 00:00:00' and time<'�URDATE() 00:00:00' group by *,* order by time; �� , �� and time>='2010-12-20 �� CURDATE(), �� , �� =(

�� $date � bash �� (madmax11)

Thu, 10 Feb 2011 06:54:00 GMT

>> �� , �� 7 ��.
> �� (NOW(), CURDATE()) �� .

�� , �� =) http://www.opennet.ru/openforum/vsluhforumID9/8991.html

�� $date � bash �� (phpcoder)

Thu, 10 Feb 2011 06:44:29 GMT

> �� , �� 7 ��.

�� (NOW(), CURDATE()) �� .

�� $date � bash �� (madmax11)

Thu, 10 Feb 2011 06:30:12 GMT

>[�� ]
>> �� "and time>=",
> �� . ��
> � ��? �� ?
> printf "select day(time),hour(time), sum(msg_len) from info where (locate('***',***)=1
> or locate('***',***)=1) and time>='%s' and time<'%s' group by *,* order by
> time;" "$(date -d 'week ago' '+%F 00:00:00')" "$(date '+%F 00:00:00')" |
> mysql -u user -ppassword database -h host
>> �� mysql �
>> �� , �� , �� .
> http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-add

�� bash �� select day(time),hour(time), sum(msg_len) from info where (locate('***',***)=1 or locate('***',***)=1) and time>='2010-12-20 00:00:00' and time<'2010-12-27 00:00:00' group by *,* order by time; � �� and time>='2010-12-20 00:00:00' and time<'2010-12-27 00:00:00 ��

�� $date � bash �� (phpcoder)

Thu, 10 Feb 2011 06:06:42 GMT

> ��, �� "and time>=" �
> �� "and time>=" �� , �� , ��
> �� "and time>=",

�� . �� ? �� ?

printf "select day(time),hour(time), sum(msg_len) from info where (locate('***',***)=1 or locate('***',***)=1) and time>='%s' and time<'%s' group by *,* order by time;" "$(date -d 'week ago' '+%F 00:00:00')" "$(date '+%F 00:00:00')" | mysql -u user -ppassword database -h host

> �� mysql �
> �� , �� , �� .

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-add

�� $date � bash �� (madmax11)

Thu, 10 Feb 2011 05:55:58 GMT

>[�� ]
>> �� , ��
>> �� "and time>=" �� , ��
>> �� date, �� ?
>> �� :
>> select day(time),hour(time), sum(msg_len) from info where (locate('***',***)=1 or locate('***',***)=1)
>> and time>='2010-12-20 00:00:00' and time<'2010-12-27 00:00:00' group by *,* order by
>> time;
> date -d 'week ago' �� (�� info date, ��), ��
> � �� . �� , �
> MySQL �� .

��, �� "and time>=" � �� "and time>=" �� , �� , �� "and time>=", �� mysql � �� , �� , �� .

�� $date � bash �� (phpcoder)

Thu, 10 Feb 2011 05:47:41 GMT

> �� perl, �� mysql ��
> �� , �� bash ��
> �� , ��
> �� "and time>=" �� , ��
> �� date, �� ?
> �� :
> select day(time),hour(time), sum(msg_len) from info where (locate('***',***)=1 or locate('***',***)=1)
> and time>='2010-12-20 00:00:00' and time<'2010-12-27 00:00:00' group by *,* order by
> time;

date -d 'week ago' �� (�� info date, ��), �� . �� , � MySQL �� .

OpenForum RSS: ��� ����������� ���������� $date � bash �������

��� ����������� ���������� $date � bash ������� (madmax11)

��� ����������� ���������� $date � bash ������� (phpcoder)

��� ����������� ���������� $date � bash ������� (madmax11)

��� ����������� ���������� $date � bash ������� (madmax11)

��� ����������� ���������� $date � bash ������� (phpcoder)

��� ����������� ���������� $date � bash ������� (madmax11)

��� ����������� ���������� $date � bash ������� (phpcoder)

��� ����������� ���������� $date � bash ������� (madmax11)

��� ����������� ���������� $date � bash ������� (phpcoder)

OpenForum RSS: �� $date � bash ��

�� $date � bash �� (madmax11)

�� $date � bash �� (phpcoder)

�� $date � bash �� (madmax11)

�� $date � bash �� (madmax11)

�� $date � bash �� (phpcoder)

�� $date � bash �� (madmax11)

�� $date � bash �� (phpcoder)

�� $date � bash �� (madmax11)

�� $date � bash �� (phpcoder)