Use [`DATE()`](https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_date) function:

    select * from follow_queue group by DATE(follow_date)

I want to check code from the repository http://code.sixapart.com/svn/perlbal/ . I can only access the the repository url by setting a proxy. I guess if I want to get the code from the same URL by svn I need to configure a proxy, too. So does anyone of you could tell me how to configure a HTTP proxy in svn? 

By the way, I use the command-line `svn` client under Linux.


How to configure a HTTP proxy for svn

I want to programmatically [in C] calculate CPU usage % for a given process ID in Linux.

How can we get the realtime CPU usage % for a given process?

To make it further clear:

 - I should be able to determine the CPU usage for the provided processid or process.  
 - The process need not be the child process.  
 - I want the solution in &#39;C&#39; language.

How to calculate the CPU usage of a process by PID in Linux from C?

My query is this. I have a bunch of entries and i want to group them by date. But instead of having date in my database, I have a datetime field. What do I do?

    select * from follow_queue group by follow_date cast follow_date as date

That&#39;s not working.

How to cast DATETIME as a DATE in mysql?

My query is this. I have a bunch of entries and i want to group them by date. But instead of having date in my database, I have a datetime field. What do I do?
<pre><code class="hljs language-vbnet">select * from follow_queue group by follow_date cast follow_date as date
</code></pre>
That's not working.

How to select data from mysql table past date to current date? For example, Select data from 1 january 2009 until current date ??

My column &quot;datetime&quot; is in datetime date type. Please help, thanks


Edit:

If let say i want to get day per day data from 1 january 2009, how to write the query? Use count and between function? 

Select mysql query between date?

I&#39;m trying to select all rows that contain only alphanumeric characters in MySQL using:

    SELECT * FROM table WHERE column REGEXP &#39;[A-Za-z0-9]&#39;;

However, it&#39;s returning all rows, regardless of the fact that they contain non-alphanumeric characters.


SELECT only rows that contain only alphanumeric characters in MySQL

I&#39;m setting up a table that might have upwards of 70 columns. I&#39;m now thinking about splitting it up as some of the data in the columns won&#39;t be needed every time the table is accessed. Then again, if I do this I&#39;m left with having to use joins. 

At what point, if any, is it considered too many columns? 

mysql - how many columns is too many?

Maybe it&#39;s an obvious question, but I want to be sure.

How can i know if it MySQLnd is the active driver?

I&#39;m runing PHP 5.3 and MySQL 5.1.37.
In phpinfo() mysqlnd is listed but only with this I can&#39;t be sure if I&#39;m using MySQLnd or the old driver...

Extract of phpinfo() output

    mysql
    MySQL Support	enabled
    Active Persistent Links 	0
    Active Links 	0
    Client API version 	mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $ 
    
    mysqli
    MysqlI Support	enabled
    Client API library version 	mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $
    Active Persistent Links 	0
    Inactive Persistent Links 	0
    Active Links 	26 
    
    mysqlnd
    mysqlnd	enabled
    Version 	mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $ 
    
    PDO
    PDO support	enabled
    PDO drivers 	mysql
    
    pdo_mysql
    PDO Driver for MySQL	enabled
    Client API version 	mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $ 

I&#39;m using PDO, and PDO driver says mysql...




How to know if MySQLnd is the active driver?

We offer a platform for video- and audio-clips, photos and vector-grafics. We started with MySQL as the database backend and recently included [MongoDB][1] for storing all meta-information of the files, because MongoDB better fits the requirements. For example: photos may have [Exif][2] information, videos may have audio-tracks where we to want to store the meta-information of, too. Videos and vector-graphics don&#39;t share any common meta-information, etc. so I know, that MongoDB is perfect to store this unstructured data and keep it searchable.

However, we continue developing our platform and adding features. Now one of the next steps will be providing a forum for our users. The question that now arises is: use the MySQL database, which would be a good choice for storing forums and forum-posts, etc. or use MongoDB for this, too?

So the question is: when to use MongoDB and when to use a RDBMS. What would you take, mongoDB or MySQL, if you had the choice and why would you take it?

  [1]: http://www.mongodb.org/display/DOCS/Home
  [2]: http://en.wikipedia.org/wiki/Exchangeable_image_file_format


When to use MongoDB or other document oriented database systems?

My date objects in JavaScript are always represented by UTC +2 because of where I am located. Hence like this

    Mon Sep 28 10:00:00 UTC+0200 2009

Problem is doing a `JSON.stringify` converts the above date to 

    2009-09-28T08:00:00Z  (notice 2 hours missing i.e. 8 instead of 10)

What I need is for the date and time to be honoured but it&#39;s not, hence it should be

    2009-09-28T10:00:00Z  (this is how it should be)

Basically I use this:

    var jsonData = JSON.stringify(jsonObject);

I tried passing a replacer parameter (second parameter on stringify) but the problem is that the value has already been processed.

I also tried using `toString()` and `toUTCString()` on the date object, but these don&#39;t give me what I want either..

Can anyone help me?




JSON Stringify changes time of date because of UTC

Using .NET 3.5

I want to determine if the current time falls in a time range.

So far I have the currentime:

    DateTime currentTime = new DateTime();
    currentTime.TimeOfDay;

I&#39;m blanking out on how to get the time range converted and compared.
Would this work?

    if (Convert.ToDateTime(&quot;11:59&quot;) &lt;= currentTime.TimeOfDay 
        &amp;&amp; Convert.ToDateTime(&quot;13:01&quot;) &gt;= currentTime.TimeOfDay)
    {
       //match found
    }
                

UPDATE1: Thanks everyone for your suggestions.  I wasn&#39;t familiar with the TimeSpan function.

Find if current time falls in a time range

What is the cleanest and most Pythonic way to get tomorrow&#39;s date? There must be a better way than to add one to the day, handle days at the end of the month, etc.

Cleanest and most Pythonic way to get tomorrow&#39;s date?

I was playing around with Javascript creating a simple countdown clock when I came across this strange behavior:

    var a = new Date(), 
    now = a.getTime(),
    then = Date.UTC(2009,10,31),
    diff = then - now,
    daysleft = parseInt(diff/(24*60*60*1000));
    console.log(daysleft );

The days left is off by 30 days.

What is wrong with this code?

Edit: I changed the variable names to make it more clear. 

Javascript Date.UTC() function is off by a month?

2009-10-05 18:11:08

2009-10-05 18:07:13


This should generate 235,how to do it ?

Get interval seconds between two datetime in PHP?

I&#39;m sure there&#39;s a good simple elegant one-liner in Ruby to give you the number of days in a given month, accounting for year, such as &quot;February 1997&quot;.  What is it?

How to get the number of days in a given month in Ruby, accounting for year?

How do I get the current date in JavaScript?


Can you please help me in solving this problem. I am trying to order the results of an SQL query by date, but I&#39;m not getting the results I need.

The query I&#39;m using is:

    SELECT date FROM tbemp ORDER BY date ASC


Results are:

    01/02/2009
    03/01/2009
    04/06/2009
    05/03/2009
    06/12/2008
    07/02/2009

Results should be:

    06/12/2008
    03/01/2009
    01/02/2009
    07/02/2009

I need to select the date in the format above. 

Your help is much appreciated.


Content Type	Original Author	Original Content on Stackoverflow
Question	Zack Burt	View Question on Stackoverflow
Solution 1 - Mysql	ChssPly76	View Answer on Stackoverflow

How to cast DATETIME as a DATE in mysql?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

How to calculate the CPU usage of a process by PID in Linux from C?

How to configure a HTTP proxy for svn

Attributions