how retrieve date format field from the my sql database in c# application

1.00/5 (1 vote)

See more:

hi
in my application i inserted date time value from the datetime picker to the mysql database .but when i try to retrieve that field from the table by using the select query it is not retrieving the value it is returning an empty field what could be the reason
please replay me

regards

ginnas

Posted 6-Sep-12 22:51pm

ginnas

Add a Solution

Comments

Shaunak De 7-Sep-12 4:53am

Try checking the database via the command line. I do suspect the insert did not work

Ganesh Nikam 7-Sep-12 4:55am

can you paste the Query

ginnas 7-Sep-12 5:39am

select fieldname from tablename where condition

Vedangi 7-Sep-12 4:57am

What is Datatype in Database ? Is it inserted properly ?

ginnas 7-Sep-12 5:38am

date only
inserted correctly and it is showing in the database also{mysql work bench]

Menon Santosh 7-Sep-12 5:55am

in what format you are saving the date in database

Ganesh Nikam 7-Sep-12 6:22am

please check date format either it is match with Mysql when inserting in db

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

...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)

Last 24hrs

This month

Rick York	55
Richard Deeming	55
Richard MacCutchan	50
Pete O'Hanlon	45
Ravi Bhavnani	36

Pete O'Hanlon	2,340
OriginalGriff	1,778
Graeme_Grant	1,160
Richard Deeming	893
Dave Kreskowiak	869