This:

    STR_TO_DATE(t.datestring, &#39;%d/%m/%Y&#39;)

...will convert the string into a datetime datatype.  To be sure that it comes out in the format you desire, use [DATE_FORMAT][1]:

    DATE_FORMAT(STR_TO_DATE(t.datestring, &#39;%d/%m/%Y&#39;), &#39;%Y-%m-%d&#39;)

If you can&#39;t change the datatype on the original column, I suggest [creating a view][2] that uses the `STR_TO_DATE` call to convert the string to a DateTime data type.


  [1]: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format
  [2]: http://dev.mysql.com/doc/refman/5.0/en/create-view.html

Yes, there&#39;s [str_to_date][1]

    mysql&gt; select str_to_date(&quot;03/02/2009&quot;,&quot;%d/%m/%Y&quot;);
    +--------------------------------------+
    | str_to_date(&quot;03/02/2009&quot;,&quot;%d/%m/%Y&quot;) |
    +--------------------------------------+
    | 2009-02-03                           |
    +--------------------------------------+
    1 row in set (0.00 sec)


  [1]: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date

[STR_TO_DATE][1] allows you to do this, and it has a format argument.


  [1]: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date

    SELECT STR_TO_DATE(dateString, &#39;%d/%m/%y&#39;) FROM yourTable...

I am creating a web app that will use OpenID logins and OAuth tokens with Youtube.  I am currently storing the OpenID identity and OAuth token/token secret in plain text in the database.

Is it inappropriate to store these values as plain text?  I could use a one-way encryption for the OpenID identifier but I don&#39;t know if that is necessary.  For the OAuth tokens, I would need to use a two-way encryption as my app relies on getting the session token for some uses.

Is it necessary to encrypt the OpenID identity?  Could someone use it to gain access to a user&#39;s account?

Securly Storing OpenID identifiers and OAuth tokens

I&#39;ve a class like this:

    public class PersonViewModel : ViewModelBase //Here is the INotifyPropertyChanged Stuff
    {
        public PersonViewModel(Person person)
        {
            PersonEntity = person;
        }

        public Person PersonEntity { 
            get { return PersonEntity.Name; }
            private set { PersonEntity.Name = value; RaisePropertyChanged(&quot;PersonEntity&quot;);
        }

        public string Name { 
            get { return PersonEntity.Name; }
            set { PersonEntity.Name = value; RaisePropertyChanged(&quot;Name&quot;);
        } 
        public int Age{ 
            get { return PersonEntity.Age; }
            set { PersonEntity.Age= value; RaisePropertyChanged(&quot;Age&quot;);
        } 

        public void ChangePerson(Person newPerson)
        {
            //Some Validation..
            PersonEntity = newPerson;
        }

My TextBoxes are bound to Name and Age of the ViewModel.
If I change the _person object in the ViewModel, do I have to call for each Property a RaisePropertyChanged again or is there a way to do this automaticly (in my concret example I have about 15 Properties..)?

Thanks for any help.

Cheers
Joseph

C#/WPF: PropertyChanged for all Properties in ViewModel?

I&#39;m using a system where the dates are stored as strings in the format `dd/mm/yyyy`. Is it possible to convert this to `yyyy-mm-dd` in a SELECT query (so that I can use `DATE_FORMAT` on it)? Does MySQL have a date parsing function?

Currently the only method I can think of is to concatenate a bunch of substrings, but hopefully there&#39;s a simpler solution.

(Unfortunately I can&#39;t convert the field to a true date field since it&#39;s a meta-table: the same column contains values for different fields that are just strings.)

Converting a date in MySQL from string field

I'm using a system where the dates are stored as strings in the format <code>dd/mm/yyyy</code>. Is it possible to convert this to <code>yyyy-mm-dd</code> in a SELECT query (so that I can use <code>DATE_FORMAT</code> on it)? Does MySQL have a date parsing function?
Currently the only method I can think of is to concatenate a bunch of substrings, but hopefully there's a simpler solution.
(Unfortunately I can't convert the field to a true date field since it's a meta-table: the same column contains values for different fields that are just strings.)

In MySQL, can I select columns only where something exists? 

For example, I have the following query:

    select phone, phone2
    from jewishyellow.users
    where phone like &#39;813%&#39;
    and phone2

I&#39;m trying to select only the rows where phone starts with 813 and phone2 has something in it.

MySQL select where column is not empty

    SELECT * FROM table ORDER BY string_length(column);

Is there a MySQL function to do this (of course instead of `string_length`)?



MySQL - How to select data by string length

I need to insert a long row with 32 fields into a MySQL table.

I&#39;d like to do something like this:

    $sql=&quot;insert into tblname values (... 32 fields ...)&quot;;

Obviously it works fine if the fields are in the same order as the MySQL table fields. But, my table has an auto-increment id as it&#39;s first field.

What I want is to fill in all table names but the first (id) one.

Suggestions?

PHP MYSQL - Insert into without using column names but with autoincrement field

I&#39;m looking for a way to update just a portion of a string via MySQL query.  

For example, if I have 10 records all containing &#39;string&#39; as part of the field value (i.e., &#39;something/string&#39;, &#39;something/stringlookhere&#39;, &#39;something/string/etcetera&#39;, is there a way to change &#39;string&#39; to &#39;anothervalue&#39; for each row via one query, so that the result is &#39;something/anothervalue&#39;, &#39;something/anothervaluelookhere&#39;, &#39;something/string/etcetera&#39;, is there a way to change &#39;anothervalue&#39;

MySql - Way to update portion of a string?

I have a huge table and I need to process all rows in it. I&#39;m always getting this Lost connection message and I&#39;m not able to reconnect and restore the cursor to the last position it was. This is basically the code I have here:

    #
    import MySQLdb

    class DB:
      conn = None
    
      def connect(self):
        self.conn = MySQLdb.connect(&#39;hostname&#39;, &#39;user&#39;, &#39;*****&#39;, &#39;some_table&#39;, cursorclass=MySQLdb.cursors.SSCursor)
    
      def query(self, sql):
        try:
         cursor = self.conn.cursor()
         cursor.execute(sql)
       except (AttributeError, MySQLdb.OperationalError):
         self.connect()
         cursor = self.conn.cursor()
         cursor.execute(sql)
       return cursor
    #

    #
    db = DB()
    sql = &quot;SELECT bla FROM foo&quot;
    data = db.query(sql)

    for row in data:
        do_something(row)
    #

But I&#39;m always getting this:

    #
    Traceback (most recent call last):
      File &quot;teste.py&quot;, line 124, in &lt;module&gt;
       run()
     File &quot;teste.py&quot;, line 109, in run
       for row in data:
     File &quot;/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py&quot;, line 417, in next
       row = self.fetchone()
     File &quot;/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py&quot;, line 388, in fetchone
       r = self._fetch_row(1)
     File &quot;/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py&quot;, line 285, in _fetch_row
       return self._result.fetch_row(size, self._fetch_type)
       _mysql_exceptions.OperationalError: (2013, &#39;Lost connection to MySQL server during query&#39;)
        Exception _mysql_exceptions.OperationalError: (2013, &#39;Lost connection to MySQL server during query&#39;) in &lt;bound method SSCursor.__del__ of &lt;MySQLdb.cursors.SSCursor object at 0x7f7e3c8da410&gt;&gt; ignored
    #

Do you have any idea?

Lost connection to MySQL server during query

I want to get last month&#39;s date. I wrote this out:

    $prevmonth = date(&#39;M Y&#39;);

Which gives me the current month/year.  I can&#39;t tell if I should use `strtotime`, `mktime`. Something to the timestamp? Do I need to add something afterwards to reset so that the date isn&#39;t set to last month throughout everything for all timestamps on my site? I&#39;m trying to RTM but it&#39;s hard for me to figure this out.

Getting last month&#39;s date in php

I&#39;m using `java.text.SimpleDateFormat` to parse strings of the form `&quot;yyyyMMdd&quot;`.

If I try to parse a string with a month greater than 12, instead of failing, it rolls over to the next year. Full runnable repro:

    import java.text.ParseException;
    import java.text.SimpleDateFormat;
    import java.util.Date;
    
    public class ParseDateTest {
    
    	public static void main(String[] args) throws ParseException {
    
    		SimpleDateFormat format = new SimpleDateFormat(&quot;yyyyMMdd&quot;);
    		Date result = format.parse(&quot;20091504&quot;); // &lt;- should not be a valid date!
    		System.out.println(result); // prints Thu Mar 04 00:00:00 CST 2010
    	}
     }

I would rather have a `ParseException` thrown.

Is there any non-hacky way of forcing the exception to happen?. I mean, I don&#39;t want to manually check if the month is greater than 12. That&#39;s kind of ridiculous.

Thanks for any suggestion.

NOTE: I already know about Joda Time, but I need this done in plain JDK without external libraries.

Make SimpleDateFormat.parse() fail on invalid dates (e.g. month is greater than 12)

I have a Java Date object containing date and time information. I want to write a method that cuts off the time information, truncates the hours-minutes-seconds, so I only have the date left.

Example input:

    2008-01-01 13:15:00

Expected output:

    2008-01-01 00:00:00

Do you have a tip? I tried doing something like this:

    (timestamp / (24 * 60 * 60 * 1000)) * (24 * 60 * 60 * 1000)

but I ran into problems with the timezone.

Java Date cut off time information

HTTP Last-Modified header contains date in following format (example):  
`Wed, 09 Apr 2008 23:55:38 GMT`  
What is the easiest way to parse **java.util.Date** from this string?

How to parse Date from HTTP Last-Modified header?

Is there a built-in method for converting a `date` to a `datetime` in Python, for example getting the `datetime` for the midnight of the given date? The opposite conversion is easy: `datetime` has a `.date()` method.

Do I really have to manually call `datetime(d.year, d.month, d.day)`?

Content Type	Original Author	Original Content on Stackoverflow
Question	DisgruntledGoat	View Question on Stackoverflow
Solution 1 - Mysql	OMG Ponies	View Answer on Stackoverflow
Solution 2 - Mysql	nos	View Answer on Stackoverflow
Solution 3 - Mysql	monksy	View Answer on Stackoverflow
Solution 4 - Mysql	h4rp0	View Answer on Stackoverflow

Converting a date in MySQL from string field

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

C#/WPF: PropertyChanged for all Properties in ViewModel?

Securly Storing OpenID identifiers and OAuth tokens

Attributions