Click here to Skip to main content
11,804,008 members (82,038 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: C# Windows

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


Posted 6-Sep-12 22:51pm
Shaunak De at 7-Sep-12 4:53am
Try checking the database via the command line. I do suspect the insert did not work
Ganesh Nikam at 7-Sep-12 4:55am
can you paste the Query
ginnas at 7-Sep-12 5:39am
select fieldname from tablename where condition
Vedangi at 7-Sep-12 4:57am
What is Datatype in Database ? Is it inserted properly ?
ginnas at 7-Sep-12 5:38am
date only
inserted correctly and it is showing in the database also{mysql work bench]
Menon Santosh at 7-Sep-12 5:55am
in what format you are saving the date in database
Ganesh Nikam at 7-Sep-12 6:22am
please check date format either it is match with Mysql when inserting in db

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

  Print Answers RSS
0 OriginalGriff 430
1 CPallini 320
2 Sergey Alexandrovich Kryukov 234
3 CHill60 230
4 Suvendu Shekhar Giri 200
0 OriginalGriff 3,000
1 Maciej Los 1,910
2 KrunalRohit 1,862
3 CPallini 1,755
4 Richard MacCutchan 1,187

Advertise | Privacy | Mobile
Web01 | 2.8.151002.1 | Last Updated 7 Sep 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100