Click here to Skip to main content
12,889,329 members (52,102 online)
Rate this:
 
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 22:51pm
ginnas467
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
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]
ginnas 7-Sep-12 5:39am
   
select fieldname from tablename where condition
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

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

    Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.170424.1 | Last Updated 7 Sep 2012
Copyright © CodeProject, 1999-2017
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