String to DateTime convertion

Analysis of the feasibility of asking the above Question?

In the body of the questions there are 122 characters (without any spaces),

(Assume)
If each character take .1 seconds to type so that will come up .1x122=12.2 seconds.

The question itself 26 characters (without any spaces) so that will be .1x26 = 2.6 seconds.

And Depending the internet speed and familiarity of the Codeproject’s ask a questions section, I would assume it will take another 1 mins to submit the questions (OP).

On top using the based assumption (without using any prediction or learning algorithm for calculating the time frequency) of the Codeproject’s question answer time frequency I would assume it will take another (at least) 5 mins to get a answer back.

So it comes up al together 5mins + 12.2 seconds + 2.6 seconds = 5mins 14.8 seconds.

Where as while I type the question in the www.google.com[^] website it will come up the 12,900,000 results within .39 seconds (depending on my internet speed)

Still I would believe this will save OP’s lots of time and as well as improve their research skills to find out the solution for a problem.

If You are getting Date From Database You can use the above Query in stored procedure

This link Wil give You More Info About Date Time Formatting...
http://www.technoreader.com/SQL-Server-Date-Time-Format.aspx[^]
or You can use this ShorDateTime Function

string to_date2;
to_date2 = DateTime.Now.ToShortDateString();
DateTime today;
today = DateTime.Parse(to_date2);
string to_day;
to_day = today.ToString(("yyyy-MM-dd"));

Hi,

Just try this:

string oldFormat="1957-08-27 12:00:00.000";
            string newFormat = Convert.ToDateTime(oldFormat).ToString("dd/MM/yyyy");

try this..

string.Format(string, "dd/mmm/yyyy")
string.Format("{0:dd/MM/yyyy}",string)

Try this article

http://msdn.microsoft.com/en-us/library/1k1skd40.aspx[^]

Try this:

SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]