Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# Windows
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 23:51pm
ginnas460
Comments
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)



Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 7 Sep 2012
Copyright © CodeProject, 1999-2014
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