For questions like this, it is always worth taking a look in the manual first. [Date and time functions in the mySQL manual][1]

`CURDATE()` returns the DATE part of the current time. [Manual on CURDATE()][2]

`NOW()` returns the date and time portions as a timestamp in various formats, depending on how it was requested. [Manual on NOW()][3].


  [1]: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
  [2]: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_curdate
  [3]: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_now

Just for the fun of it:

    CURDATE() = DATE(NOW())

Or

    NOW() = CONCAT(CURDATE(), &#39; &#39;, CURTIME())

`CURDATE()` will give current date while `NOW()` will give full date time.

Run the queries, and you will find out whats the difference between them.

    SELECT NOW();     -- You will get 2010-12-09 17:10:18
    SELECT CURDATE(); -- You will get 2010-12-09

Actually MySQL provide a lot of easy to use function in daily life without more effort from user side-

**NOW()**  it produce date and time both in current scenario whereas
**CURDATE()**  produce date only, **CURTIME()** display time only, we can use one of them according to our need with **CAST** or merge other calculation it, MySQL rich in these type of function.

**NOTE:-** *You can see the difference using query select NOW() as NOWDATETIME, CURDATE() as NOWDATE, CURTIME() as NOWTIME ;*     

I need to insert HTML content into an XML document, is this possible or should HTML content be, for example, encoded in BASE64 or with something else like that?

Is it possible to insert HTML content in XML document?

Given this CSV file:

    &quot;A&quot;,&quot;B&quot;,&quot;C&quot;,&quot;D&quot;,&quot;E&quot;,&quot;F&quot;,&quot;timestamp&quot;
    611.88243,9089.5601,5133.0,864.07514,1715.37476,765.22777,1.291111964948E12
    611.88243,9089.5601,5133.0,864.07514,1715.37476,765.22777,1.291113113366E12
    611.88243,9089.5601,5133.0,864.07514,1715.37476,765.22777,1.291120650486E12

I simply want to load it as a matrix/ndarray with 3 rows and 7 columns.  However, for some reason, all I can get out of numpy is an ndarray with 3 rows (one per line) and no columns.

    r = np.genfromtxt(fname,delimiter=&#39;,&#39;,dtype=None, names=True)
    print r
    print r.shape
    
    [ (611.88243, 9089.5601000000006, 5133.0, 864.07514000000003, 1715.3747599999999, 765.22776999999996, 1291111964948.0)
     (611.88243, 9089.5601000000006, 5133.0, 864.07514000000003, 1715.3747599999999, 765.22776999999996, 1291113113366.0)
     (611.88243, 9089.5601000000006, 5133.0, 864.07514000000003, 1715.3747599999999, 765.22776999999996, 1291120650486.0)]
    (3,)

I can manually iterate and hack it into the shape I want, but this seems silly.  I just want to load it as a proper matrix so I can slice it across different dimensions and plot it, just like in matlab.

load csv into 2D matrix with numpy for plotting

What is difference between MySQL `Curdate()` and `Now()`?

MySQL: Curdate() vs Now()

<p>What is difference between MySQL <code>Curdate()</code> and <code>Now()</code>?</p>


How can I get the current timestamp using a mysql query?

Getting timestamp using MySQL

So I&#39;ve been looking through the internet the last hour, reading and looking for the definitive answer to this simple question.

What is the default JOIN in MySQL?

    SELECT * FROM t1 JOIN t2

Is that the same as

    SELECT * FROM t1, t2
    
    OR

    SELECT * FROM t1 INNER JOIN t2


Also a related question, when you use &quot;WHERE&quot; clauses, is it the same as JOIN or INNER JOIN ?

Right now I&#39;m thinking a stand-alone JOIN is identical to using commas and WHERE clauses.

What is the default MySQL JOIN behaviour, INNER or OUTER?

According to MySQL, a `text` column holds 65,535 bytes.

So if this a legitimate boundary then will it actually only fit about 32k UTF-8 characters, right? Or is this one of those &quot;fuzzy&quot; boundaries where the guys that wrote the docs can&#39;t tell characters from bytes and it will actually allow ~64k UTF-8 characters if set to something like `utf8_general_ci`?

How much UTF-8 text fits in a MySQL &quot;Text&quot; field?

I stumbled into a delicate SQL problem when I needed to use a value from a field inside a LIKE %..% statement.

Example:

    SELECT t1.Notes, t2.Name
    FROM Table1 t1, Table2 t2
    WHERE t1.Notes LIKE &#39;%t2.Name%&#39;

This is only an example from the top of my head to show what I need to do (I know this will not work). I need to use the value of t2.Name inside the LIKE %..%
  
I guess this is trivial when you know it ;)

Use LIKE %..% with field values in MySQL

I have a simple mysql table:

    CREATE TABLE IF NOT EXISTS `pers` (
      `persID` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(35) NOT NULL,
      `gehalt` int(11) NOT NULL,
      `chefID` int(11) DEFAULT NULL,
      PRIMARY KEY (`persID`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
    
    INSERT INTO `pers` (`persID`, `name`, `gehalt`, `chefID`) VALUES
    (1, &#39;blb&#39;, 1000, 3),
    (2, &#39;as&#39;, 1000, 3),
    (3, &#39;chef&#39;, 1040, NULL);

I tried to run following update, but I get only the error 1093:  

    UPDATE pers P 
    SET P.gehalt = P.gehalt * 1.05 
    WHERE (P.chefID IS NOT NULL 
    OR gehalt &lt; 
    (SELECT (
    	SELECT MAX(gehalt * 1.05) 
    	FROM pers MA 
    	WHERE MA.chefID = MA.chefID) 
    	AS _pers
    ))

I searched for the error and found from mysql following page http://dev.mysql.com/doc/refman/5.1/en/subquery-restrictions.html, but it doesn&#39;t help me.

What shall I do to correct the sql query?


You can&#39;t specify target table for update in FROM clause

I have a query that returns the following rows:

StateId, OrderId, OrderTime, PermitId

I need to return only the rows that are exact duplicates all across the board so each record must be exctly the same as the other record for it to be a duplicate. I would like to return both records. These reocrds are mixed in with a bunch of records that do not have duplicates...

Any idea?

SQL Return only duplicate rows

Can you help me with SQL statements to find duplicates on multiple fields?

For example, in pseudo code:

    select count(field1,field2,field3) 
    from table 
    where the combination of field1, field2, field3 occurs multiple times

and from the above statement *if there are multiple occurrences* I would like to select *every record except the first one*.

Select statement to find duplicates on certain fields

I am creating a script that will be run in a MS SQL server. This script will run multiple statements and needs to be transactional, if one of the statement fails the overall execution is stopped and any changes are rolled back.

I am having trouble creating this transactional model when issuing ALTER TABLE statements to add columns to a table and then updating the newly added column. In order to access the newly added column right away, I use a GO command to execute the ALTER TABLE statement, and then call my UPDATE statement. The problem I am facing is that I cannot issue a GO command inside an IF statement. The IF statement is important within my transactional model. This is a sample code of the script I am trying to run. Also notice that issuing a  GO command, will discard the @errorCode variable, and will need to be declared down in the code before being used (This is not in the code below).

    BEGIN TRANSACTION
    
    DECLARE @errorCode INT
    SET @errorCode = @@ERROR
    
    -- **********************************
    -- * Settings
    -- **********************************
    IF @errorCode = 0
    BEGIN
     BEGIN TRY
      ALTER TABLE Color ADD [CodeID] [uniqueidentifier] NOT NULL DEFAULT (&#39;{00000000-0000-0000-0000-000000000000}&#39;)
      GO
     END TRY
     BEGIN CATCH
      SET @errorCode = @@ERROR
     END CATCH
    END
    
    IF @errorCode = 0
    BEGIN
     BEGIN TRY
      UPDATE Color
      SET CodeID= &#39;B6D266DC-B305-4153-A7AB-9109962255FC&#39;
      WHERE [Name] = &#39;Red&#39;
     END TRY
     BEGIN CATCH
      SET @errorCode = @@ERROR
     END CATCH
    END
    
    -- **********************************
    -- * Check @errorCode to issue a COMMIT or a ROLLBACK
    -- **********************************
    IF @errorCode = 0
    BEGIN
     COMMIT
     PRINT &#39;Success&#39;
    END
    ELSE 
    BEGIN
     ROLLBACK
     PRINT &#39;Failure&#39;
    END

So what I would like to know is how to go around this problem, issuing ALTER TABLE statements to add a column and then updating that column, all within a script executing as a transactional unit.

Add column to table and then update it inside transaction

I&#39;m still wrapping my head around this library, but I&#39;m out of time so I&#39;ll just skip to the spoiler section and ask.  With a given, arbitrary millisecond time value (like the kind you&#39;d gave from `.getTime()`), how do I get the current minute, hour, day, week of the month, month, week of the year, and year of that specific millisecond of time?

Additionally, how do I retrieve the number of days of a given month?  Anything I should know about regarding leap years and other stuff?

Javascript, Time and Date: Getting the current minute, hour, day, week, month, year of a given millisecond time

Code speaks a million words:


    php &gt; echo strtotime(&quot;2010-12-07T23:00:00.000Z&quot;);
    1291762800
    echo date(&#39;c&#39;, 1291762800);
    2010-12-08T00:00:00+01:00
    php &gt; var_dump(DateTime::createFromFormat(&#39;c&#39;, &quot;2010-12-07T23:00:00.000Z&quot;));
    bool(false)
    php &gt; var_dump(DateTime::createFromFormat(DateTime::ISO8601, &quot;2010-12-07T23:00:00.000Z&quot;));
    bool(false)

Any idea what&#39;s going on? 

Btw, yes, new DateTime(&quot;2010-12-07T23:00:00.000Z&quot;) works fine. But I prefer to know what input I am getting. 

PHP DateTime::createFromFormat doesn&#39;t parse ISO 8601 date time

    var range = getDates(new Date(), new Date().addDays(7));

I&#39;d like &quot;range&quot; to be an array of date objects, one for each day between the two dates.

The trick is that it should handle month and year boundaries as well.


Javascript - get array of dates between 2 dates

Is there a more efficient way of doing this below? I want to have the difference in years between two dates as a single scalar. Any suggestions are welcome.

    from datetime import datetime
    start_date = datetime(2010,4,28,12,33)
    end_date = datetime(2010,5,5,23,14)
    difference  = end_date - start_date
    difference_in_years = (difference.days + difference.seconds/86400)/365.2425

Pythonic difference between two dates in years?

In Python, how can I convert a string like this:

&gt; Thu, 16 Dec 2010 12:14:05 +0000

to ISO 8601 format, while keeping the timezone?

Please note that the orginal date is string, and the output should be string too, not `datetime` or something like that.

I have no problem to use third parties libraries, though.

Content Type	Original Author	Original Content on Stackoverflow
Question	user529649	View Question on Stackoverflow
Solution 1 - Mysql	Pekka	View Answer on Stackoverflow
Solution 2 - Mysql	Jonathan Joosten	View Answer on Stackoverflow
Solution 3 - Mysql	Sanjay Khatri	View Answer on Stackoverflow
Solution 4 - Mysql	Sonpal singh Sengar	View Answer on Stackoverflow

MySQL: Curdate() vs Now()

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

load csv into 2D matrix with numpy for plotting

Is it possible to insert HTML content in XML document?

Attributions