dateTime Picker in C# Winforms

Question

0.00/5 (No votes)

See more:

hi,

am using datetimepicker to select date&time as 24 hour format(yyyy-MM-dd HH:mm:ss), and am storing that in Mysql Database,and database is showing correctly as what i selected.

but the problem is when i select that from database it is giving 12 hour format,

but i want as it is , what i entered.

How to solve it
any Suggestions.......

Posted 25-Feb-14 21:44pm

Member 10263519

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-02-25T21:50:00

No, it isn't - it's giving it as a DateTime object. What is happening is that you are converting the DateTime to a string, using the default conversion for your system, which is set as 12 hour with AM / PM.

Instead of using the default formatter, you can select a specific format to convert your data - see here: Formatting a DateTime for display - format string description[^]

george4986 · Answer 2 · 2014-02-25T22:07:00

Solution 2

plz tag this question in MYSQL

use selection of date column as

SQL

SELECT DATE_FORMAT('2013-02-04 19:38:12', '%Y-%m-%d %H:%m:%s') as date

if ur column is 'orderdate' of table order

SQL

SELECT DATE_FORMAT(orderdate, '%Y-%m-%d %H:%m:%s') as date FROM order

Posted 25-Feb-14 22:07pm

george4986

Updated 25-Feb-14 23:40pm

v2

Comments

Member 10263519 26-Feb-14 5:19am

ok,
but if i use following;

using (MySqlConnection con = new MySqlConnection(ConnectionString))
{

String query = "select DATE_FORMAT(date, '%Y-%m-%d %H:%m:%s') from acc";
MySqlCommand command = new MySqlCommand(query, con);
con.Open();
using (MySqlDataReader rdr = command.ExecuteReader())
{
if (rdr.Read())
{

DateTime t = Convert.ToDateTime(rdr["date"]);
String s = rdr["date"].ToString();

MessageBox.Show("value:" + t);
}
}
}

acc table is having only 1 column

date datetime

giving error as IndexOutofbounds exception
Could not find specified column in results: date

george4986 26-Feb-14 5:41am

because column name doesn't specified check updated solution

Member 10263519 26-Feb-14 5:25am

IndexOutOfRange exception at datetime t=convert.todatetime(rdr["date"])

george4986 26-Feb-14 5:34am

try below code

using (MySqlConnection con = new MySqlConnection(ConnectionString))
{

String query = "select DATE_FORMAT(date, '%Y-%m-%d %H:%m:%s') as date from acc";
MySqlCommand command = new MySqlCommand(query, con);
con.Open();
using (MySqlDataReader rdr = command.ExecuteReader())
{
if (rdr.Read())
{

DateTime t = Convert.ToDateTime(rdr["date"]);
String s = rdr["date"].ToString();

MessageBox.Show("value:" + t);
}
}
}

Member 10263519 26-Feb-14 6:15am

thanks alot

george4986 26-Feb-14 6:19am

happy to hear it works. gud luck ;-)