Click here to Skip to main content
15,882,802 members
Home / Discussions / C#
   

C#

 
QuestionODBC Type mismatch error Pin
TheJudeDude26-Oct-09 9:25
TheJudeDude26-Oct-09 9:25 
AnswerRe: ODBC Type mismatch error Pin
Abhishek Sur26-Oct-09 10:01
professionalAbhishek Sur26-Oct-09 10:01 
GeneralRe: ODBC Type mismatch error Pin
TheJudeDude26-Oct-09 11:46
TheJudeDude26-Oct-09 11:46 
AnswerRe: ODBC Type mismatch error Pin
OriginalGriff26-Oct-09 10:02
mveOriginalGriff26-Oct-09 10:02 
GeneralRe: ODBC Type mismatch error Pin
TheJudeDude26-Oct-09 11:51
TheJudeDude26-Oct-09 11:51 
GeneralRe: ODBC Type mismatch error Pin
Luc Pattyn26-Oct-09 12:22
sitebuilderLuc Pattyn26-Oct-09 12:22 
GeneralRe: ODBC Type mismatch error Pin
TheJudeDude26-Oct-09 13:19
TheJudeDude26-Oct-09 13:19 
GeneralRe: ODBC Type mismatch error Pin
Luc Pattyn26-Oct-09 13:40
sitebuilderLuc Pattyn26-Oct-09 13:40 
TheJudeDude wrote:
I was trying it for troubleshooting


troubleshooting code better be correct too.


TheJudeDude wrote:
When I query just the date I get a MM/DD/YYYY HH:MM:SS AM/PM in return


No. the database returns a date, which is a struct containing some numbers. And for human consumption your PC converts that into a string, according to some rules, by default influenced by the Regional Settings. That Control Panel is exactly how the human user tells the system what he likes to use as date and time formats. An explicit formatting string allows you to specify a different format, independent of Regional Settings.

SQL wants date/datetime according to ISO 8601, which means dashes in the date, colons in the time, year-month-day order, a 'T' in between, etc etc. The delimiter (quote, hash, whatever) may depend on the exact database.

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages


GeneralRe: ODBC Type mismatch error Pin
TheJudeDude26-Oct-09 14:10
TheJudeDude26-Oct-09 14:10 
GeneralRe: ODBC Type mismatch error Pin
Luc Pattyn26-Oct-09 14:18
sitebuilderLuc Pattyn26-Oct-09 14:18 
GeneralRe: ODBC Type mismatch error Pin
TheJudeDude26-Oct-09 14:42
TheJudeDude26-Oct-09 14:42 
GeneralRe: ODBC Type mismatch error Pin
Luc Pattyn26-Oct-09 14:53
sitebuilderLuc Pattyn26-Oct-09 14:53 
GeneralRe: ODBC Type mismatch error Pin
TheJudeDude26-Oct-09 15:41
TheJudeDude26-Oct-09 15:41 
GeneralRe: ODBC Type mismatch error Pin
Luc Pattyn26-Oct-09 15:46
sitebuilderLuc Pattyn26-Oct-09 15:46 
GeneralRe: ODBC Type mismatch error Pin
TheJudeDude27-Oct-09 3:49
TheJudeDude27-Oct-09 3:49 
AnswerRe: ODBC Type mismatch error Pin
Luc Pattyn26-Oct-09 10:05
sitebuilderLuc Pattyn26-Oct-09 10:05 
QuestionChecking required fields in a second Windows Form Pin
JTRizos26-Oct-09 8:31
JTRizos26-Oct-09 8:31 
AnswerRe: Checking required fields in a second Windows Form Pin
Not Active26-Oct-09 8:50
mentorNot Active26-Oct-09 8:50 
GeneralRe: Checking required fields in a second Windows Form Pin
JTRizos26-Oct-09 11:09
JTRizos26-Oct-09 11:09 
GeneralRe: Checking required fields in a second Windows Form Pin
Not Active26-Oct-09 11:26
mentorNot Active26-Oct-09 11:26 
GeneralRe: Checking required fields in a second Windows Form Pin
JTRizos26-Oct-09 11:56
JTRizos26-Oct-09 11:56 
GeneralRe: Checking required fields in a second Windows Form Pin
Not Active26-Oct-09 12:44
mentorNot Active26-Oct-09 12:44 
GeneralRe: Checking required fields in a second Windows Form Pin
JTRizos26-Oct-09 13:03
JTRizos26-Oct-09 13:03 
GeneralRe: Checking required fields in a second Windows Form Pin
CodyDaemon29-Oct-09 5:54
CodyDaemon29-Oct-09 5:54 
GeneralRe: Checking required fields in a second Windows Form Pin
JTRizos29-Oct-09 6:24
JTRizos29-Oct-09 6:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.