Copied from the MySQL Documentation:

[TIMESTAMP(expr), TIMESTAMP(expr1,expr2)](http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_timestamp)

&gt; With a single argument, this function returns the date or datetime expression expr as a datetime value. With two arguments, it adds the time expression expr2 to the date or datetime expression expr1 and returns the result as a datetime value.

    mysql&gt; SELECT TIMESTAMP(&#39;2003-12-31&#39;);
        -&gt; &#39;2003-12-31 00:00:00&#39;
    mysql&gt; SELECT TIMESTAMP(&#39;2003-12-31 12:00:00&#39;,&#39;12:00:00&#39;);
        -&gt; &#39;2004-01-01 00:00:00&#39;

To get a *true* `DATETIME` value from your two separate `DATE` and `TIME` values:

    STR_TO_DATE(CONCAT(date, &#39; &#39;, time), &#39;%Y-%m-%d %H:%i:%s&#39;)

You could use `ADDTIME()`:

    ADDTIME(CONVERT(date, DATETIME), time)

- `date` may be a date string or a `DATE` object.
- `time` may be a time string  or a `TIME` object.

Tested in MySQL 5.5.

    datetime = CONCAT(date, &#39; &#39;, time);

    select timestamp(&#39;2003-12-31 12:00:00&#39;,&#39;12:00:00&#39;); 
works, when the string is formatted correctly. Otherwise, you can just include the time using str_to_date. 
    
    select str_to_date(&#39;12/31/2003 14:59&#39;,&#39;%m/%d/%Y %H:%i&#39;);

Without creating and parsing strings, just add an interval to the date:

    set @dt_text = &#39;1964-05-13 15:34:05.757&#39; ;
    set @d = date(@dt_text) ;
    set @t = time(@dt_text) ;
    select @d, @t, @d + interval time_to_sec( @t ) second;

However this truncates the microseconds.

I agree with Muki - be sure to take account of time zones and daylight savings time!

I am having trouble with the delimiter in the TStringList Class. Take a look:

    var
      s: string;
      sl: TStringList;
    
    begin
      sl := TStringList.Create;
      s := &#39;Users^foo bar^bar foo^foobar^barfoo&#39;;
      sl.Delimiter := &#39;^&#39;;
      sl.DelimitedText := s;
      ShowMessage(sl[1]);
    end;

`sl[1]` SHOULD return `&#39;foo bar&#39;`

`sl[1]` DOES return `&#39;foo&#39;`

It seems that the delimiter is now `&#39;^&#39;` AND `&#39; &#39;`

Any ideas?

Delphi: StringList Delimiter is always a space character even if Delimiter is set

How can I step through JDK source code in IntelliJ IDEA 7 and see the debug info?  I can currently hit breakpoints and step through the code, but the debug info is not available.  This means I can&#39;t see the value of local variables.

I only want to step through the source code of one class, if that matters.  
For what it&#39;s worth, it&#39;s the `javax.swing.text.html.HTMLDocument` class and I do have a copy of the corresponding `.java` file.


Step through JDK source code in IntelliJ IDEA

Is there way in MySQL to create DATETIME from a given attribute of type DATE and a given attribute of type TIME?

Creating DATETIME from DATE and TIME

<p>Is there way in MySQL to create DATETIME from a given attribute of type DATE and a given attribute of type TIME?</p>


I recently found and fixed a bug in a site I was working on that resulted in millions of duplicate rows of data in a table that will be quite large even without them (still in the millions). I can easily find these duplicate rows and can run a single delete query to kill them all. The problem is that trying to delete this many rows in one shot locks up the table for a long time, which I would like to avoid if possible. The only ways I can see to get rid of these rows, without taking down the site (by locking up the table) are:

 1. Write a script that will execute thousands of smaller delete queries in a loop. This will theoretically get around the locked table issue because other queries will be able to make it into the queue and run in between the deletes. But it will still spike the load on the database quite a bit and will take a long time to run.
 2. Rename the table and recreate the existing table (it&#39;ll now be empty). Then do my cleanup on the renamed table. Rename the new table, name the old one back and merge the new rows into the renamed table. This is way takes considerably more steps, but should get the job done with minimal interruption. The only tricky part here is that the table in question is a reporting table, so once it&#39;s renamed out of the way and the empty one put in its place all historic reports go away until I put it back in place. Plus the merging process could be a bit of a pain because of the type of data being stored. Overall this is my likely choice right now.

I was just wondering if anyone else has had this problem before and, if so, how you dealt with it without taking down the site and, hopefully, with minimal if any interruption to the users? If I go with number 2, or a different, similar, approach, I can schedule the stuff to run late at night and do the merge early the next morning and just let the users know ahead of time, so that&#39;s not a huge deal. I&#39;m just looking to see if anyone has any ideas for a better, or easier, way to do the cleanup.

Deleting millions of rows in MySQL

I have a PHP array with numbers of ID&#39;s in it. These numbers are already ordered.

Now i would like to get my result via the IN() method, to get all of the ID&#39;s.

However, these ID&#39;s should be ordered like in the IN method.

For example:

    IN(4,7,3,8,9)  
Should give a result like:

    4 - Article 4  
    7 - Article 7  
    3 - Article 3  
    8 - Article 8  
    9 - Article 9

Any suggestions?  Maybe there is a function to do this?

Thanks!

MySQL ORDER BY IN()

I am in the process of fixing some bad UTF-8 encoding. I am currently using PHP 5 and MySQL.

In my database I have a few instances of bad encodings that print like: &#195;ƒ&#194;&#174;

 - The database collation is utf8_general_ci
 - PHP is using a proper UTF-8 header
 - Notepad++ is set to use UTF-8 without BOM
 - database management is handled in [phpMyAdmin][1]
 - not all cases of accented characters are broken

I need some sort of function that will help me map the instances of &#195;ƒ&#194;&#174;, &#195;ƒ&#194;&#173;, &#195;ƒ&#194;&#188; and others like it to their proper accented UTF-8 characters.

  [1]: http://en.wikipedia.org/wiki/PhpMyAdmin


Fixing broken UTF-8 encoding

I keep getting MySQL error #1054, when trying to perform this update query:

    UPDATE MASTER_USER_PROFILE, TRAN_USER_BRANCH
    SET MASTER_USER_PROFILE.fellow=`y`
    WHERE MASTER_USER_PROFILE.USER_ID = TRAN_USER_BRANCH.USER_ID
    AND TRAN_USER_BRANCH.BRANCH_ID = 17

It&#39;s probably some syntax error, but I&#39;ve tried using an inner join instead and other alterations, but I keep getting the same message:

    Unknown column &#39;y&#39; in &#39;field list&#39; 


Unknown column in &#39;field list&#39; error on MySQL Update query

I am trying to find a MySQL query that will find DISTINCT values in a particular field, count the number of occurrences of that value and then order the results by the count.

example db

    id         name
    -----      ------
    1          Mark
    2          Mike
    3          Paul
    4          Mike
    5          Mike
    6          John
    7          Mark

expected result

    name       count
    -----      -----
    Mike       3
    Mark       2
    Paul       1
    John       1



Count the occurrences of DISTINCT values

This snippet of code always parses the date into the current timezone, and not into the timezone in the string being parsed.     

    final DateTimeFormatter df = DateTimeFormat
            .forPattern(&quot;EEE MMM dd HH:mm:ss &#39;GMT&#39;Z yyyy&quot;);
    final DateTime dateTime = df
            .parseDateTime(&quot;Mon Aug 24 12:36:46 GMT+1000 2009&quot;);
    System.out.println(&quot;dateTime = &quot; + dateTime);
    // outputs dateTime = 2009-08-24T04:36:46.000+02:00


It outputs:

    dateTime = 2009-08-24T04:36:46.000+02:00

whereas I expect:

    dateTime = 2009-08-24T04:36:46.000+10:00

Any ideas what I&#39;m doing wrong?


How can I parse a date including timezone with Joda Time

I&#39;ve got a datatable with 5 columns, where a row is being filled with data then saved to the database via a transaction.

While saving, an error is returned:

&gt;The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value

It implies, as read, that my datatable has a type of `DateTime2` and my database a `DateTime`; that is wrong.

The date column is set to a `DateTime` like this: 

`new DataColumn(&quot;myDate&quot;, Type.GetType(&quot;System.DateTime&quot;))`

**Question**

Can this be solved in code or does something have to be changed on a database level?

Conversion of a datetime2 data type to a datetime data type results out-of-range value

Which one: 

 - [`datetime`][1]
 - [`datetime2`][2]

is *the* recommended way to store date and time in SQL Server 2008+?

I&#39;m aware of differences in precision (and storage space probably), but ignoring those for now, is there a best practice document on when to use what, or maybe we should just use `datetime2` only?


  [1]: https://msdn.microsoft.com/en-us/library/ms187819.aspx
  [2]: https://msdn.microsoft.com/en-us/library/bb677335.aspx

DateTime2 vs DateTime in SQL Server

How do I tell the time difference in minutes between two `datetime` objects?


How do I find the time difference between two datetime objects in python?

I have a string that looks like this: &quot;9/1/2009&quot;. I want to convert it to a DateTime object (using C#).

This works:

    DateTime.Parse(&quot;9/1/2009&quot;, new CultureInfo(&quot;en-US&quot;));

But I don&#39;t understand why this doesn&#39;t work:

    DateTime.ParseExact(&quot;9/1/2009&quot;, &quot;M/d/yyyy&quot;, null);

There&#39;s no word in the date (like &quot;September&quot;), and I know the specific format, so I&#39;d rather use ParseExact (and I don&#39;t see why CultureInfo would be needed). But I keep getting the dreaded &quot;String was not recognized as a valid DateTime&quot; exception.

Thanks

A little follow up. Here are 3 approaches that work:

    DateTime.ParseExact(&quot;9/1/2009&quot;, &quot;M&#39;/&#39;d&#39;/&#39;yyyy&quot;, null);
    DateTime.ParseExact(&quot;9/1/2009&quot;, &quot;M/d/yyyy&quot;, CultureInfo.InvariantCulture);
    DateTime.Parse(&quot;9/1/2009&quot;, new CultureInfo(&quot;en-US&quot;));

And here are 3 that don&#39;t work:

    DateTime.ParseExact(&quot;9/1/2009&quot;, &quot;M/d/yyyy&quot;, CultureInfo.CurrentCulture);
    DateTime.ParseExact(&quot;9/1/2009&quot;, &quot;M/d/yyyy&quot;, new CultureInfo(&quot;en-US&quot;));
    DateTime.ParseExact(&quot;9/1/2009&quot;, &quot;M/d/yyyy&quot;, null);

So, Parse() works with &quot;en-US&quot;, but not ParseExact... Unexpected?


Content Type	Original Author	Original Content on Stackoverflow
Question	gregor	View Question on Stackoverflow
Solution 1 - Mysql	johnson	View Answer on Stackoverflow
Solution 2 - Mysql	CDuv	View Answer on Stackoverflow
Solution 3 - Mysql	SystemParadox	View Answer on Stackoverflow
Solution 4 - Mysql	Zed	View Answer on Stackoverflow
Solution 5 - Mysql	Christian	View Answer on Stackoverflow
Solution 6 - Mysql	Michael Grazebrook	View Answer on Stackoverflow

Creating DATETIME from DATE and TIME

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

Solution 5 - Mysql

Solution 6 - Mysql

Step through JDK source code in IntelliJ IDEA

Delphi: StringList Delimiter is always a space character even if Delimiter is set

Attributions