Click here to Skip to main content
15,613,866 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: format date Pin
alexfromto22-Feb-07 7:58
alexfromto22-Feb-07 7:58 
AnswerRe: format date Pin
alexfromto22-Feb-07 8:14
alexfromto22-Feb-07 8:14 
GeneralRe: format date Pin
Marcus J. Smith22-Feb-07 8:19
professionalMarcus J. Smith22-Feb-07 8:19 
GeneralRe: format date Pin
alexfromto22-Feb-07 8:22
alexfromto22-Feb-07 8:22 
GeneralRe: format date Pin
Marcus J. Smith22-Feb-07 9:04
professionalMarcus J. Smith22-Feb-07 9:04 
GeneralRe: format date Pin
jds120722-Feb-07 8:43
jds120722-Feb-07 8:43 
GeneralRe: format date Pin
alexfromto22-Feb-07 8:53
alexfromto22-Feb-07 8:53 
AnswerRe: format date Pin
Dave Kreskowiak22-Feb-07 8:45
mveDave Kreskowiak22-Feb-07 8:45 
First, the Date/Time in any SQL database doesn't have a format. The format only applies when the data is displayed, not when it's stored.

If you database and code is setup properly, you don't have to worry about the format at all. Using a parameterized query, the parameter objects worry about the conversion for you. All you have to do is pass in a DateTime object into the parameters Value property.

You can read up on parameterized queries here[^].


Dave Kreskowiak
Microsoft MVP - Visual Basic


GeneralRe: format date Pin
alexfromto22-Feb-07 8:58
alexfromto22-Feb-07 8:58 
GeneralRe: format date Pin
jds120722-Feb-07 9:22
jds120722-Feb-07 9:22 
GeneralRe: format date Pin
Dave Kreskowiak22-Feb-07 9:27
mveDave Kreskowiak22-Feb-07 9:27 
GeneralRe: format date Pin
tonymathewt22-Feb-07 17:06
professionaltonymathewt22-Feb-07 17:06 
GeneralRe: format date Pin
Dave Kreskowiak23-Feb-07 2:08
mveDave Kreskowiak23-Feb-07 2:08 
QuestionExchange Pin
alexfromto22-Feb-07 7:27
alexfromto22-Feb-07 7:27 
AnswerRe: Exchange Pin
Dave Kreskowiak22-Feb-07 8:41
mveDave Kreskowiak22-Feb-07 8:41 
GeneralRe: Exchange Pin
alexfromto22-Feb-07 9:03
alexfromto22-Feb-07 9:03 
GeneralRe: Exchange Pin
Dave Kreskowiak22-Feb-07 9:22
mveDave Kreskowiak22-Feb-07 9:22 
GeneralRe: Exchange Pin
alexfromto22-Feb-07 9:30
alexfromto22-Feb-07 9:30 
GeneralRe: Exchange Pin
Dave Kreskowiak22-Feb-07 9:59
mveDave Kreskowiak22-Feb-07 9:59 
GeneralRe: Exchange Pin
alexfromto22-Feb-07 10:40
alexfromto22-Feb-07 10:40 
GeneralRe: Exchange Pin
Dave Kreskowiak22-Feb-07 11:57
mveDave Kreskowiak22-Feb-07 11:57 
QuestionDisplaying forms Pin
jady8422-Feb-07 7:17
jady8422-Feb-07 7:17 
AnswerRe: Displaying forms Pin
Dave Kreskowiak22-Feb-07 8:38
mveDave Kreskowiak22-Feb-07 8:38 
AnswerRe: Displaying forms Pin
TwoFaced22-Feb-07 9:10
TwoFaced22-Feb-07 9:10 
QuestionOleDB error Pin
7prince22-Feb-07 7:10
7prince22-Feb-07 7:10 

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.