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

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